Calculate a weighted average based on text category

I am developing a formula to calculate a weighted average based on category (red, yellow, green). Each row will be assigned a weighted value adding up to 1.

The idea would be to determine if the overall state is red, yellow, green based on the weighted score. There is more info in the spreadsheet I attached. Thanks.

Book1.xlsx

One simple tinker ..

In O19:O21, put these labels
GREEN
YELLOW
RED

Then in P19: =SUMIF($O$12:$O$17,O19,$G$12:$G$17)
Copy down to P21 to calculate the total weights per stoplight

Then in P12: =INDEX(O19:O21,MATCH(MAX(P19:P21),P19:P21,0))
In the event of any ties in the max weight, the less severe stoplight will be indicated.
Flip the labels order in O19:O21 if you want it the other way around
-----------------------------------------
Any good? Wave it, click the little star at the bottom left of my response