Hi,

Am Thu, 25 Apr 2013 16:12:58 +0100 schrieb KH3557:

Column A: Date of Incident

Column B: Category of Incident – Cat 1 = slip, trip or fall, cat 2 =
physical assault and so on up to cat 10.

Column C: Summary

I was wondering if there is a way to count the number of times each
category occurs between date ranges that will automatically populate the
table that drives the graphs?

for Cat 1 between 1/1/13 and 3/31/13 try:
=SUMPRODUCT(--($A$2:$A$1000=DATE(2013,1,1)),--($A$2:$A$1000<=DATE(2013,3,31)),--($B$2:$B$1000="Cat 1"))



Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2