CountIfs when you need to count two results in the same column

I am creating a Summary Chart to summarize Yes No N/A data. I am summarizing the percentage of Yes responses. Where I am having issues is getting the denominator to calculate correctly. I want the denominator to count only the Yes and No answers (not blanks or N/As). I have tried countifs(A:A,"Yes",A:A,"No"), which returns a 0. I have tried countif(A:A,and("Yes","No"), which also returns a 0. I'm sure it's a syntax error, but I can't figure out what the issue is.

I still get a 0 when I do that. Thank you.

When I put that as part of my equation in field Summary Chart!B3 to get my percentage, it's telling me that there is an error.

Here is my calculated field, as it currently stands: =IF(Data!$A:$A='Summary Chart'!$A3,(COUNTIFS(Data!$A:$A,$A3,Data!D:D,"Yes")/COUNTIFS(Data!$A:$A,'Summary Chart'!$A3,SUM(COUNTIF(Data!D:D,{"Yes","No"])))),"")

It should return 89% (16 Yesses/18 answers). Week 1 has 19 entries, but only 18 were answered for question 1A. Since the weeks will change, that is why I have the data limiting itself to week 1 (we will be entering week 2, week 3, etc.).

Nevermind, there are also N/A answers..

There it is. Thank you so much, Tony!