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
13289
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
November 22, 2019
495
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