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

Biff

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