Excel Count If

[U. Elmalak]

I am running into a strange issue with Microsoft Excel. I
have a formula as follows:
=COUNTIF(AN3:AN82,"< .1")

On most machines, it works perfectly with no problem.
However in a few locations outside of the US, it counts
the blank cells in addition to the one's <.1 which gives
an invalid result.

Only a few people encountered this problem. I am thinking
it maybe something with the excel version (ie
international) etc.. but unable to confirm.

Any help would be appreciated!

 

[J.E. McGimpsey]

More likely it's because they use "," as a decimal separator, so to
their versions, ".1" is just a text string. That won't cause
COUNTIF() to count blank cells, but it will count any cells which
contain text, including the null string ("") or a space (" ").

Try

=COUNTIF(A3:A82,"<" & 0.1)

(which will translate, since the 0.1 is no longer part of a string)
instead.