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!

steps to be taken care
1. remove white spaces before and after the number, use TRIM function to remove
2. make sure that all the cells are formatted as number instead of text.