=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"))