COUNTIFS #name error

**qwertyjjj** · 10-27-2014, 04:50 PM

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.

**ConneXionLost** · 10-27-2014, 05:02 PM

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,

**qwertyjjj** · 10-27-2014, 05:06 PM

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.

**ConneXionLost** · 10-27-2014, 05:34 PM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic