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