總分 依代码換數值 (12707)

C5=SUMPRODUCT((LEN(B5)-LEN(SUBSTITUTE(B5,B$1:F$1,)))*B$2:F$2)

另解=SUMPRODUCT((MID(B5,{1;2;3},1)=B$1:F$1)*B$2:F$2)