Exclude "0" from COUNT function

[e.cichlid]

Hi All,

I want to COUNT the occurance that any number appears in a cell (I do not want to SUM them). How can I exclude "0" from being counted? I'd rather not leave the cell blank.

Thank you.

 

[Jonmo1]

Welcome to the board...

It does work..
Perhaps a better question is "Why doesn't it do what I want it to do?"

To answer that, we need to know what you wanted it to do..

What result does it give?
What result did you expect it to give, and why?


Most likely it results in a higher number than you expect because it count's Blanks and Text Strings as NOT 0..

 

[enejorg]

It gives me a result of 0 and I was expecting a count excluding the cells with a zero.

 

[Jonmo1]

If this formula returns 0
=COUNTIF(G132:G6503, "<>0")
It means that ALL the values in G132:G6503 are equal to 0.

Also, you may have calculation set to Manual, or a Circular reference.
If you put that formula within the range G132:G6503, then that's a circular reference.

 

[smuneeb]

If this formula returns 0
=COUNTIF(G132:G6503, "<>0")
It means that ALL the values in G132:G6503 are equal to 0.

Also, you may have calculation set to Manual, or a Circular reference.
If you put that formula within the range G132:G6503, then that's a circular reference.

Hi
=COUNTIFS(G132:G6503,"<>",G132:G6503,"<>0",G132:G6503,"<>0*")
It will count only those values which is greater and lest than 0
Thanks