How do I count items within a date range in Excel?

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" <tcolbert@discussions.microsoft.com> wrote in message
news:67964770-F879-4636-BF2C-F35D3A1BBF3C@microsoft.com...
> 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!