### Possible Answer

... , Is there an argument like F5=39 where I could say F5 "DOES NOT EQUAL" 39? Is there some... Home; Mail; News; Sports; Finance; Weather; Games ... Just make a formula =f5<>39 and push enter and it will Show the True value if f5 is not equal to ... "Is Not Equal To" argument in Excel? - read more

this is "not equal" "<>" If it will not work in the "countif" criteria then put it a n "if " formula in its own column referring to your data e.g if data <> to 0 then "1" else "0". - read more

Please vote if the answer you were given helped you or not, thats the best way to improve our algorithm. You can also submit an answer or search documents about excel formula does not equal.