總和 分大 小於条件 (10986)

J2=SUMPRODUCT((SIGN(G$2:G$14)=-1^(I$1=I1))*D$2:D$14*F$2:F$14)

另解{=SUM(COUNTIF(OFFSET(G$1,ROW($1:$13),),RIGHT(I2,2))*D$2:D$14*F$2:F$14)