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
7098
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 10, 2021
489
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