Percentage total in Spreadsheet counting Yes and NA as a percentage total

[LouisS]

Hello

I want to make a simple table that counts "Yes" and "NA" as a positive and gives me a percentage total.
For example if I had a list of 10 cells and I had 8 Yes, 1 NA and 1 No I want it to give me a result of 90%

I have played around with formulas and can get this
=COUNTIF(A4:A13, "Yes")/COUNTA(A4:A13) but it doesn't count the NA in the stats

I have tried this but the answer I get is 89%
=COUNTIF(B4:B13, "Yes") / (COUNTIF(B4:B13, "Yes") + COUNTIF(B4:B13, "NA"))

Sadly, this is as close as I can get. I do not have enough experience with Excel to solve this so any help would be appreciated.

Thanks,

Louis

 

[Fluff]

Hi & welcome to MrExcel.
Try
=(COUNTIF(A4:A13, "Yes")+COUNTIF(A4:A13, "NA"))/COUNTA(A4:A13)

 

[LouisS]

Hi & welcome to MrExcel.
Try
=(COUNTIF(A4:A13, "Yes")+COUNTIF(A4:A13, "NA"))/COUNTA(A4:A13)

Thank you so much - that worked perfectly. I am under pressure at a new job to do a lot of extra work I am not trained for and you've saved me a lot of time.

 

[Fluff]

You're welcome & thanks for the feedback