二項不重複取出後計總和 (14111)

F3:G3下拉{=IFERROR(INDEX(A:A,SMALL(IF((MATCH($A$3:$A$99&$B$3:$B$99,$A$3:$A$99&$B$3:$B$99,)=ROW($1:$97))*($A$3:$A$99>0),ROW($3:$99)),ROW(A1))),"")

H3下拉=IF(F3="","",SUMIFS(C:C,A:A,F3,B:B,G3))



留言