Hi every one I'm trying to countif some values but not the empty ones this is my formula and this is the data that I try to count:

=COUNTIF(B2:B15,"<0.8, >=0")

But this formula counts the empty one too, I would like to have only one like in the image in colum b should be count only 2 but it count 13. Help please!

CodePudding user response：

Try

=COUNTIFS(B2:B15,"<0.8",B2:B15,">0")

COUNTIFS

or

=SUMPRODUCT((B2:B15<0.8)*(B2:B15>0))

SUMRPODUCT