Forum Discussion
COUNTIF not working
I have a list of 25 numbers in one column (range). There is one "0" in the list. In another cell when I use =COUNTIF(range, "=0"), I get a value of "1" as you would expect. HOWEVER, when I use...
You'll need to share your workbook. Your syntax is just fine, so something else is going on.
Side note: I'd recommend using COUNTIFS() vs COUNTIF(). They both do the same thing for 1 criteria, but with COUNTIFS() you can add additional criteria. If you start with COUNTIF() and want to add more, you have to change the function and the order of your parameters. Same with SUMIFS(). Never use SUMIF().
Side note: I'd recommend using COUNTIFS() vs COUNTIF(). They both do the same thing for 1 criteria, but with COUNTIFS() you can add additional criteria. If you start with COUNTIF() and want to add more, you have to change the function and the order of your parameters. Same with SUMIFS(). Never use SUMIF().
Thanks, Ed. I added the file to my post.