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

A

Amanda Deshotel

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?
 
A

Amanda Deshotel

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".
 
Top