assuming dates in col a
=SUMPRODUCT((YEAR(a2:a200)=2006)*1)
--
Don Guillett
SalesAid Software

"Amanda Deshotel" <Amanda wrote in
message ...
I am working on a spreadsheet for workers comp injuries. I need to have a
total of injuries broken out per year. I can't seem to get the function
to
work properly...probably because I am using the wrong one. Any ideas?