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
7073
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 24, 2020
498
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