# Counting number of cells with non zero value

This is a discussion on Counting number of cells with non zero value within the Excel Questions forums, part of the Question Forums category; Hi, consider the following table: A1, A2, A3, A4 Count, value1, value2, value3 ...x..., 12345, 23423, 0 ...y..., 0, 324234234, ...

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!

#### Posting Permissions

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