I am probably doing something wrong, but what I want to do is check for the word "Yes" in a specific range. But even when I put 'Yes' in this range, it keeps returning a value of 0. What am I doing wrong here?

enter image description here

  • The result is 0 because there is nothing to sum ... try using AANTAL.ALS (COUNTIF) instead
    – Daniele
    May 5 at 14:56

1 Answer 1


you can try the below formula =countif($K:$K,"YES")

This will count cells with yes

enter image description here

Let me know if you need help

Thank you

regards Supreeth

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.