ExcelBanter - View Single Post - calculate count on 2006 total, 2005 total, etc...

Don Guillett

simple

--
Don Guillett
SalesAid Software

"Tieske" wrote in message
...
sounds pretty complicated, why not use a simple pivot table?

Tieske

"Amanda Deshotel" wrote in
message ...
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" wrote:

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

Biff

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