Can the formula COUNTA / COUNT exclude 0 values? [Solved/Closed]

doublewitt 14 Posts Sunday April 27, 2014Registration date September 29, 2014 Last seen - Apr 28, 2014 at 11:59 AM - Latest reply: doublewitt 14 Posts Sunday April 27, 2014Registration date September 29, 2014 Last seen
- Apr 28, 2014 at 01:46 PM
If I use COUNT or COUNTA, what can I include in the formula to exclude zero values?

Thanks for any tips
See more 

2 replies

doublewitt 14 Posts Sunday April 27, 2014Registration date September 29, 2014 Last seen - Apr 28, 2014 at 01:46 PM
0
Thank you
Oh great - thanks
that works fine
aquarelle 7178 Posts Saturday April 7, 2007Registration dateModeratorStatus May 25, 2018 Last seen - Apr 28, 2014 at 01:09 PM
-1
Thank you
Hello

You should use COUNTIF(range,criteria)

If your data are in range A2 to A33, to exclude zero value, you can use this formula :
=COUNTIF(A2:A33,"<>0")

Regards