Forum Discussion
Using "No" in Countif formula
Hello all, I was trying to use a countif formula to find how many instances of "No" appeared in a range. i.e =countif(B2:B5, "=no"). Column B contains multiple instances of "No", but the formu...
Most probably you have space or non-printable character after the No. Did you add them manually or copy/paste from somewhere?
hi. thanks for your response.
I just checked, there are no spaces or additional characters after no. its written as (......., "=no")
I typed the formula in manually. When I delete the * from the formula, it doesn't work. but with the * it works.
You may always check by =LEN(cell). If more than 2 you have extra characters.
update: I now understand what you mean by space. I have sorted it out. thank you.
TobiLuf , you are welcome