I am trying to count the number of occurences of a text item within a date
range. I have tried using the COUNTIF function, but since my date is in
DD/MM/YYYY format I am unable to single out the year (ex "2004"). Example,
total number of Safety Classes in 2004 - with one column as the date and
another column listing the safety class. I can count the total number of
occurences of the safety class, I'm just having issues coordinating it with a
date range.

=SUMPRODUCT(--(YEAR(A2:A100)=2004),--(B2:B100="Safetyclass1"))

will count year 2004 in A where B is safetyclass1
adapt to fit your requirements

--

Regards,

Peo Sjoblom

"tcolbert" wrote in message
...
I am trying to count the number of occurences of a text item within a date
range. I have tried using the COUNTIF function, but since my date is in
DD/MM/YYYY format I am unable to single out the year (ex "2004"). Example,
total number of Safety Classes in 2004 - with one column as the date and
another column listing the safety class. I can count the total number of
occurences of the safety class, I'm just having issues coordinating it
with a
date range.

It worked perfectly. Thanks!