總和 每行最大數的字母 (12611)

H2=MAX(C2:G2)

K2=SUMIF(B:B,J2,H:H)

L2=SUMPRODUCT(RIGHT(SMALL(ROW($1:$8)/1%+C$2:G$9,ROW($1:$8)*5),2)*(B$2:B$9=J2))

另解 L2=SUMPRODUCT((B$2:B$9=J2)*SUBTOTAL(4,OFFSET(C$1:G$1,ROW($1:$8),)))