COUNTIF not counting properly

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!

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!

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.
--
If this helps, please remember to click yes.


"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!