客戶 不重複銷售明細與總金額 (12614)

H2:I7{=INDEX(B:B,SMALL(IF(($A$2:$A$16=$F$2)*MATCH($A$2:$A$16&$B$2:$B$16&$C$2:$C$16,$A$2:$A$16&$B$2:$B$16&$C$2:$C$16,)=ROW($1:$15),ROW($2:$16),99),ROW(A1)))&""

J2:J7=IF(H2="","",SUMIFS(D:D,A:A,F$2,B:B,H2,C:C,I2))