Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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
See more
Related:

2 replies

Answer 1 / 2
Posts
14
Registration date
Sunday April 27, 2014
Status
Member
Last seen
September 29, 2014
Oh great - thanks
that works fine
Answer 2 / 2
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
Ask a question