加總 二條件位於同格 (14068)

G2=SUMPRODUCT((MMULT(1-ISERR(FIND(B$2:C$16,F2)),{1;1})=2)*D$2:D$16)

另解=SUMPRODUCT(ISNUMBER(FIND(F2,B2:B16&","&C$2:C$16&","&B$2:B$16))*D$2:D$16)