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