• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Count all the cells that has a value

G

GN0001

Member
I have a range that has these values on each cell

column a Column b column c column d column E and so on

4.987 0.654 0 0 1.765


I need to count the cells that have values bigger than 0, any help?


Any array formula can work for this purpose?


Thanks as usual.

Guity
 
Hi ,


You don't need an array formula ; just a simple =COUNTIF(A1:E1,">0") will do.


Extend the range A1:E1 as far as you want.


Narayan
 
If you have negative numbers it should be

=COUNTIF(A1:E1,"<>0")
 
You must log in or register to reply here.
Back
Top