COUNTIF not counting properly

[DogCrazy]

Hello, I hope someone can help!

I am using the following formula: =COUNTIF(AM6:AM105,">=1.0")-(AM112+AM113)

It works great except it will not count any occurance of "1.0". The same
formula for counting ">=4.0" picks up both occurances of 4.0. Literally, it
is only 1.0 it refuses to count...help

Thank you all in advance!

 

[Eduardo]

Hi,
is the information being uploaded if yes check for blank spaces at the
beginning or at the end of 1.0

 

[Paul C]

I can think of two things to check

1) make sure your value is actually 1.0 and not something like .99999999999
displaying as 1
- try changing your formula to >=.9 and see if that changes the result

2) Check that the cell containg 1.0 are not formatted as text.