加總 先取二項目不重複 (13578)

F2:G8{=INDEX(B:B,RIGHT(MIN(IF(COUNTIFS($F$1:$F1,$B$2:$B$16,$G$1:$G1,$C$2:$C$16)=0,MATCH($B$2:$B$16,$B:$B,)/1%%+MATCH($C$2:$C$16,$C:$C,)/1%+ROW($2:$16)),"1E9"+99),2))&""

H2:H8=IF(F2="","",SUMIFS(D:D,B:B,F2,C:C,G2))