加總 符號後面同字符 (11553)

F2=SUMPRODUCT((1-ISNA(MATCH(MID(B$2:B$10,FIND("-",B$2:B$10)+1,9),E2,)))*C$2:C$10)

另解(E2:E4 長度長需放下面){=SUM(N(MMULT(1-ISERR(FIND(TRANSPOSE(E$2:E$4),B$2:B$10)),{1;1;1})=ROW(A1))*C$2:C$10)