總和 二欄各多項 (13919)

I2=SUMPRODUCT(COUNTIF(G2,"*"&A$2:A$5&"*")*COUNTIF(H2,"*"&B$1:D$1&"*")*B$2:D$5)

另解=SUMPRODUCT(ISNUMBER(FIND(A$2:A$5,G2))*ISNUMBER(FIND(B$1:D$1,H2))*B$2:D$5)