Excel Count If

  • Thread starter Thread starter U. Elmalak
  • Start date Start date
U

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!
 
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.
 
Back
Top