Formula for break up score

Hi,
I have 2 columns one with yes,no answers and the corresponding category.The combined score of the yes,no answers are displayed in the cell "E1".
I want to display the break up score of the individual categories i.e. A,B,C separately also.
I want to perform this action without using the filter.
(in the attached sheet the score for category A is 100%)
Thank you.
Attachment 1137

Aplly below formula with CSE (Ctrl + Shift + Enter) as it is an array formula

=SUM(N(($E$4:$E$21=$G1) * ($D$4:$D$21="Yes")))/SUM(N(($E$4:$E$21=$G1)*($D$4:$D$21 = {"Yes","No"})))

and drag this formula till value "C" in column G

If it is not working then could you please tell us how you are calculating indivisual score.

Quote:

---

Originally Posted by LalitPandey87

Aplly below formula with CSE (Ctrl + Shift + Enter) as it is an array formula

=SUM(N(($E$4:$E$21=$G1) * ($D$4:$D$21="Yes")))/SUM(N(($E$4:$E$21=$G1)*($D$4:$D$21 = {"Yes","No"})))

and drag this formula till value "C" in column G

If it is not working then could you please tell us how you are calculating indivisual score.

---

Thanks a lot ...that helped me a lot.