Count percentage completion based on criteriavertical vs horizontal

[trimiii]

Hi,

Please see the picture attached, I need to count the driver license test based on how many they status (fail or pass... I have a list of +300+ driver).

I am using this formula to count horizontal and it works but because of my list is growing drastically, I need to count this Vertical
=SUMPRODUCT((A6:K6=LEGEND!A6:$A$9)*(LEGEND!$D$6:$D$9))

What formula should I use to count the same thing Vertical?
Example(s):
Range: D11::D21
Result on D22 (same result as a horizontal.

The "Legend" table showing the decimal for the criteria example:
P - Pass - if the driver passes the test# on the first time he gets the full points (10times tried, 10 passes = 100% score)
P-F1 - Pass after Fail Once - if driver pass after fail one, he still pass but he doesn't get full points (11 times tried, passed 10 times, he failed once so he is 90% score)
P-F2 - Pass after Fail Twice - if driver pass after fail one, he still passes but he doesn't get full points (12 times tried, passed 10 times, he failed once so he is 80% score)
P-F3 - Pass after Fail Three - if driver pass after fail one, he still passes but he doesn't get full points (13 times tried, passed 10 times, he failed once so he is 70% score)

Thanks and looking forward to reply and appreciate anyone's help.