Thanks:  0
Likes:  0

Thread: Counting number of cells with non zero value

1. Counting number of cells with non zero value

Hi,

consider the following table:

A1, A2, A3, A4
Count, value1, value2, value3
...x..., 12345, 23423, 0
...y..., 0, 324234234, 0

How to count the number of cells containing non-zero values in a row?

X should be 2 and Y should be 3.

It is easy to check the validity of on cell like : =IF(A2>0,"1","0").

But how to extend the range where the check has to be done, like (A2:A4).

Pls help,
Thanks

2. Re: Counting number of cells with non zero value

=COUNTIF(A2:A4,">"&0)

Dom

3. Re: Counting number of cells with non zero value

Originally Posted by Domski
=COUNTIF(A2:A4,">"&0)

Dom
Thanks Dom, that was quick and it works perfectly...

4. Re: Counting number of cells with non zero value

It's now six years later and this just saved me so much work... Thanks, internet!

User Tag List

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•