calculate count on 2006 total, 2005 total, etc...

[Guest]

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?

 

[Don Guillett]

assuming dates in col a
=SUMPRODUCT((YEAR(a2:a200)=2006)*1)

 

[Biff]

You need to provide at least *some* detail!!!

Biff

 

[Guest]

Here is the jist of what my spreadsheet looks like:
Column D contains injury dates in mm/dd/yy format. At the bottom of my
spreadsheet, I am breaking out the years for a total count of injuries during
that year. So, if there were 8 injuries in column d2:d33, and the year was
greater than or equal to 01/01/06, I want it to pull "8".

 

[Biff]

See Don's reply. That'll work. Just change the range.

Biff

 

[Tieske]

sounds pretty complicated, why not use a simple pivot table?

Tieske

 

[Don Guillett]

simple