單格數個序號與姓名 交叉計算總額 (13764)

G2=SUMPRODUCT(ISNUMBER(FIND(E2,B$2:B$9))*MMULT(N(TRIM(MID(SUBSTITUTE(F2,",",REPT(" ",19)),{1,2,3}*19-18,19))=A$2:A$9),{1;1;1})*C$2:C$9/(LEN(B$2:B$9)-LEN(SUBSTITUTE(B$2:B$9,",",))+1))