If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
COUNTIF not counting properly
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! |
#3
|
|||
|
|||
COUNTIF not counting properly
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! |
Thread Tools | |
Display Modes | |
|
|