L9{=INDEX($1:$1,RIGHT(SMALL(IF(ISNUMBER(FIND(B$1:I$1,L$5)),MMULT(COLUMN(A:O)^0,B$2:I$16*(A$2:A$16>=M$1)*(A$2:A$16<=M$2))*10^8+COLUMN($B:$I)),ROW(A1)),2))
M9=SUMPRODUCT(B$2:I$16*(A$2:A$16>=M$1)*(A$2:A$16<=M$2)*(B$1:I$1=L9))
B18=SUMIFS(B2:B16,$A2:$A16,">="&$M1,$A2:$A16,"<="&$M2)
留言
張貼留言