Count IF function assistance

Question

As shown above I am trying to count the cells which does not have 0 in it. But it still shows 6 where the desired output is 3. Am I doing something wrong here? This is such simple thing but I'm breaking my head over it. This is the formula i entered

=COUNTIF(AS1:AX1,"<>""0")

Thank you for the help!

Answer 1

Try the following as posted above in comments:

---

• Formula used in cell AY1

=COUNTIF(AS1:AX1,">0")

---

Or,

• Formula used in cell AZ1

=COUNTIF(AS1:AX1,"<>0")

---

Your initial formula was not working since it was considering if not equal to blank instead of not equal to 0. The criteria should be wrapped within the speechmarks/double inverted quotes ""

---