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

Report
Posts
14
Registration date
Sunday April 27, 2014
Status
Member
Last seen
September 29, 2014
-
Posts
14
Registration date
Sunday April 27, 2014
Status
Member
Last seen
September 29, 2014
-
If I use COUNT or COUNTA, what can I include in the formula to exclude zero values?

Thanks for any tips

2 replies

Posts
14
Registration date
Sunday April 27, 2014
Status
Member
Last seen
September 29, 2014

Oh great - thanks
that works fine
Posts
7096
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
February 22, 2021
482
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!