how to get number of entries without taking zero and blanks

[sumesh56]

I want to get the number of entries made in a range of cells using countif function. how to get exact number without taking the zeros and the blank cells.see the attached file.

[AlKey]

Try this

Please Login or Register  to view this content.

[Jonmo1]

If you want to still have the criteria of <32.5 as well, then

=COUNTIFS($B$2:$B$9,"<32.5",$B$2:$B$9,">0")

[sumesh56]

If you want to still have the criteria of <32.5 as well, then

=COUNTIFS($B$2:$B$9,"<32.5",$B$2:$B$9,">0")

thanks for the suggestion. this is what i wanted to get.have a nice day/

[Jonmo1]

You're welcome.