Formula for break up score

[devpp]

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.