Quote:
Originally Posted by 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!
|
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.