Not quite.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"phatbusa" wrote in message
...
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"))