Countif function not working

[Serrre]

Hi,

I want to make a pie chart for Yes/No answers.

Now it is working with ''Yes'' but not with ''No''

As seen in the R column it should give 12x ''Yes'' and 1x ''No''

No matter what i change it wont fill the ''No'' , the list in R column is a drop down list with Yes & No

Thanks for your time

 

[dreid1011]

Does the "No" in N23 contain an extra space at the end? Or maybe your Data Validation lists have an extra space after "No".

 

[Serrre]

Does the "No" in N23 contain an extra space at the end? Or maybe your Data Validation lists have an extra space after "No".

Working,

In the Dat validation there was a space between the , No