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...
Hello, the COUNTIFS returned 0 most likely because there are extra spaces. You can use TRIM to remove all the spaces as I did and then the COUNTIFS will deliver the correct values.\
