Sumproduct or countif?
that worked bob, thanks
now for the next part
I want to be able to have change the 2006 to 2005 and have a different sheet
referenced for that answer in the same cell
does that make sense?
"Bob Phillips" wrote:
=SUMPRODUCT(--('Incidents 2006'!B3:B31500=2006),
--('Incidents 2006'!E3:E1500="Injury, Lost Time"))
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"phatbusa" wrote in message
...
I'm having some issues here, I've been digging through the questions to
find
an answer and I've tried several methods but I can't seem to get it.
There
are a few different things I want to do so bear with me.
I have my dates separated into three columns b,c,d and I want to be able
to
return the number of times "Inury, Lost Time" occurs in 2006 which would
be
column b. I've tried the sumproduct but keep getting a value error
=SUMPRODUCT(--('Incidents 2006'!B3:B31500="2006"),--('Incidents
2006'!E3:E1500="Injury, Lost Time"))
|