Watch your ranges. B3:B31500 has lots more rows than E3:E1500.

And if that year field is really numeric, you may want to use =2006 (not the
string "2006").

And if that date field is really a date, you may want:

=SUMPRODUCT(--year('Incidents 2006'!B3:B31500)=2006),....



phatbusa wrote:

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

--

Dave Peterson