不重複二條件 整理與相加 (10923)

E2:F9{=IFERROR(INDEX(A:A,SMALL(IF(COUNTIFS($E$1:$E1,$A$2:$A$16,$F$1:$F1,$B$2:$B$16)=0,ROW($2:$16)),1)),"")

G2:G9=IF(E2="","",SUMIFS(C:C,A:A,E2,B:B,F2))