### Possible Answer

Is there an argument like F5=39 where I could say F5 "DOES NOT EQUAL" 39? Is there some operator that can do that? How would I accomplish that without creating an AND() argument? ... How do you get an excel formula to equal a blank instead of a ... - read more

Best Answer: 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". Then use the "1" in the new column as the criteria i.e "=1" ... =COUNTIF(F3:F37,"<>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.