Eliminate counting zero’s when using COUNT (2000)

Topic

New Reply

Hi everyone,

I’m using the COUNTIF in a column and the results show numbers, as expected.
However, there are, as well, cells that show 0’s.

On the same column, I am using latter on the functions count() and counta(). These functions count the 0’s that countif() generated.

My question:
Is there a way to “count” only the cells that DO NOT contain the 0’s?

Thanks much for your help! -Tivoli0

Reply | Quote

Replies

You could use COUNTIF again instead of COUNT or COUNTA, with “0” as condition.

Reply | Quote

Hello Hans,

Thanks, again, for your prompt help! Works like a charm!

You know, I tried to use the countif() again before I had posted my request but I couldn’t figure out the “0”.
I tried =0 with and without the “” and it didn’t work. Syntax, syntax……

Have a great day! -Tivoli0

Reply | Quote