excelexcel-formulacountifwps

Count IF function assistance

Example

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!

Solution

  • Try the following as posted above in comments:

    enter image description here

    • 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 ""