三項不重複 提取 (10987)


G2:I8{=INDEX(A:A,SMALL(IF(MATCH($A$2:$A$12&$B$2:$B$12&$C$2:$C$12,$A$2:$A$12&$B$2:$B$12&$C$2:$C$12,)=ROW($1:$11),ROW($2:$12),99),ROW(A1)))&""


J2:K8=IF(G2="","",SUMIFS($E:$E,$A:$A,$G2,$B:$B,$H2,$C:$C,$I2,$D:$D,J$1))


留言