Forum Discussion

Copper Contributor

Oct 18, 2019

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...

Silver Contributor

Oct 19, 2019

sme527

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

COUNTIF.xlsx11 KB

sme527

Copper Contributor

Oct 19, 2019

Haytham Amairah

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