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?

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?

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?

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?

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?

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?

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?