Let's say your year data is in column A. Try something like this

=SUMPRODUCT(--(YEAR(Sheet1!$A:$A)=2007))

If you want to count a specific event in the year, do this

=SUMPRODUCT(--(YEAR(Sheet1!$A:$A)=2007),--(Sheet1!$B:$B = "Event"))

--
HTH,
Barb Reinhardt



"Mytmini" wrote:

I have a list of fire events that I need to sort by year. The date field for
each event is formated as mm-dd-yyyy. I can't figure out how to restrict the
count function to just pick up the year. The data spans 40 years so I don't
want to have to write out 40 different date range functions. Any
suggestions? I thought this would be easier....