Percentage calculation question

[elarius0]

Hello everyone!
I have a scoring sheet that has a answer key of either: Yes, No, N/A. At the bottom it automatically calculates all of the Yes answers and it will give them a score. To get a 100% score you must get 53 Yes's. What i'm trying to create is if N/A is put into the cell the percentage formula will recognize that and it will change the perfect score from 53 and shorten it to however many N/A cells there are. Any help would be fantastic. Thank you!

 

[JamesLoft]

Hello, so I managed to think of something. So here is the formula =COUNTIF(A1:A4,"Yes")/COUNTIF(A1:A4,"*"), so what it does, firstly it counts the cells by ignoring the #N/A, so it counts how many questions there would be, and then it divides that question value to the how much yes there would be, and you get the value. In example in if got 10 questions, you answer 5, you get value 0.5, then you just apply conditional formmating to turn it to percentage. Worked?

 

[elarius0]

Yes JamesLoft! That worked perfectly! Thank you very much sir!