選擇項目 二區加減 (15216)

H2=SUMPRODUCT(ISNUMBER(FIND(","&A$2:A$9&",",","&F2&","))*B$2:B$9)-SUMPRODUCT(ISNUMBER(FIND(","&C$2:C$7&",",","&F2&","))*D$2:D$7)

另解{=SUM(ISNUMBER(FIND(","&IF({1,0},A$2:A$9,C$2:C$9)&",",","&F2&","))*IF({1,0},B$2:B$9,-D$2:D$9))

另解{=SUM(ISNUMBER(FIND(","&T(OFFSET(A$1,ROW($1:$99),{0,2}))&",",","&F2&","))*N(OFFSET(B$1,ROW($1:$99),{0,2}))*{1,-1})