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

"DogCrazy" wrote:

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!