總和 字母對應值 (11027)

H5=SUMPRODUCT((FIND(C$5:C$7,G5&C$5:C$7)<=LEN(G5))*D$5:D$7)

另解{=SUM(COUNTIF(G5,"*"&C$5:C$7&"*")*D$5:D$7)

另解=SUMPRODUCT(ISNUMBER(FIND(C$5:C$7,G5))*D$5:D$7)