COUNTIFS #name error

Originally Posted by ConneXionLost

Have you tried:

=COUNTIFS(EVENTS!$E$3:$E$282,">0",EVENTS!$K$3:$K$282,"=1",EVENTS!$B$3:$B$282,"=1",EVENTS!$C$3:$C$282,"=2009")

Cheers,

LOL!

No error now but all values are coming up zero.