統計二項不重複 (15064)

F2:G10{=INDEX(B:B,MIN(IF(COUNTIFS($F$1:$F1,$B$2:$B$16,$G$1:$G1,$C$2:$C$16)=0,ROW($2:$16),99)))&""

H1:H10=IF(F2="","",SUMIFS(D:D,B:B,F2,C:C,G2))



留言