S3:T18{=IFERROR(INDEX(A:A,SMALL(IF(VLOOKUP(T(IF({1},$A$3:$A$7)),IF({1,0},$F$3:$F$6,MMULT(N($G$3:$Q$6>0),ROW(1:11)^0)),2,)>=COLUMN($A:$I),ROW($3:$7)),ROW(A1))),"")
U3:V18{=IF(S3="","",INDIRECT(TEXT(SMALL(IF(($F$3:$F$6=$S3)*($G$3:$Q$6>0),IF(COLUMN(A1)=1,2,ROW($3:$6))/1%+COLUMN($G:$Q)),COUNTIFS($S$3:$S3,$S3,$T$3:$T3,$T3)),"!R0C00"),))
W3:W18=IF(S3="","",SUMIFS(C:C,A:A,S3,B:B,T3)*V3)
留言
張貼留言