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

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?

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

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?

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

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?

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

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?

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

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?

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

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?

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

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?