I'm trying to use countifs to count each time something occurs based on 4 columns but I get a #NAME? error with the formula contains unrecognised text.
The forumla I have is
=COUNTFS(EVENTS!$E$3:$E$282,">0",EVENTS!$K$3:$K$282,"=1",EVENTS!$B$3:$B$282,"=1",EVENTS!$C$3:$C$282,"=2009")

Can you see anything wrong with that?

Basically if there is a monterya value above zero in E and column K=1, and column B=1 and column C=2009 then it should be counted.
There arround 300 rows of data all with different values.