Forum Discussion
COUNTIF not working
I have a list of 25 numbers in one column (range). There is one "0" in the list. In another cell when I use =COUNTIF(range, "=0"), I get a value of "1" as you would expect. HOWEVER, when I use...
Thank you Haytham Amairah. However, on my file, I do not have the "green triangles" and the cells are formatted under Format --> Cells --> as "Number" as you can see in the image attached. It is still not working...
To convert the numbers entered as Text into real numbers, select column A --> Data Tab --> Text to Columns --> Finish.
To check if a number in a cell is a real number (not entered as Text), in any blank cell type the formula =ISNUMBER(A4)
If the formula returns TRUE, that means 4 in A4 has been converted into the real number.