Menu
Ask a question Report

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

doublewitt
Posts
14
Registration date
Sunday April 27, 2014
Last seen
September 29, 2014
 - Apr 28, 2014 at 11:59 AM - Latest reply: doublewitt
Posts
14
Registration date
Sunday April 27, 2014
Last seen
September 29, 2014
- Apr 28, 2014 at 01:46 PM
Excel Ask a question Report
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

Report Respond to doublewitt
doublewitt
Posts
14
Registration date
Sunday April 27, 2014
Last seen
September 29, 2014
 - Apr 28, 2014 at 01:46 PM
0
Thank you
Oh great - thanks
that works fine
Report Respond to aquarelle
aquarelle
Posts
7179
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
October 25, 2018
 - 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
Ask a question