H2:H5=SUMPRODUCT(LOOKUP(ROW($1:$11),ROW($1:$11)/(D$2:D$12<>""),D$2:D$12)*(LOOKUP(ROW($1:$11),ROW($1:$11)/(B$2:B$12<>""),B$2:B$12)=F2)*(LOOKUP(ROW($1:$11),ROW($1:$11)/(C$2:C$12<>""),C$2:C$12)=G2))
K2:M12=LOOKUP(IF(B$1=$D$1,4^8,"座"),B$2:B2)
I2:I5=SUMIFS(M:M,K:K,F2,L:L,G2)
留言
張貼留言