Forum Discussion
COUNTIF not working
Hi,
Please notice the green triangle in the top-left corner of each cell in the range!
This triangle indicates that the values of the cells are stored as text.
You can convert them to numbers in several ways, one of them: highlight the range, and select Convert to Number from the pop-up menu.
Hope that helps
PLEASE, I see my case was "closed" but it has not been resolved! Please see my last reply!!! The file I have does not have the cells formatted as "text" -- they are formatted as "Number" and it is still not working. Perhaps they converted to "text" when I sent it? But, if you look at the screenshot I sent, you will see, my file is accurately formatted and the function is not working. Please "reopen" my case. Or, please let me know how I can go about doing so. As I indicated in the first post, I had already ensured my formatting was accurate....
Thank you,
sme527
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.
Thank you, this worked! MOST APPRECIATED! Do you know how to make a the default setting such that I can convert the format of a group of cells to "real" "Number" format without going through the Data Tab? It is very misleading, since my Format --> Cells method has worked in the past...
Thank you,
Sarah
