H7{=COUNT(0/(MATCH(E7&LOOKUP(ROW(2:13),ROW(2:13)/(B2:B13<>""),B2:B13)&G6&F7,A2:A13&LOOKUP(ROW(2:13),ROW(2:13)/(B2:B13<>""),B2:B13)&C2:C13&D2:D13,)=ROW(1:12)))
H8{=COUNT(0/(MATCH(TRUE&LOOKUP(ROW(2:13),ROW(2:13)/(B2:B13<>""),B2:B13)&G6&F7,(A2:A13<=E7)&LOOKUP(ROW(2:13),ROW(2:13)/(B2:B13<>""),B2:B13)&C2:C13&D2:D13,)=ROW(1:12)))
一公式 G2:G8{=COUNT(0/(MATCH(E$7^(ROW(A1)=1)&LOOKUP(ROW($2:$13),ROW($2:$13)/(B$2:B$13<>""),B$2:B$13)&G$6&F7,IF(ROW(A1)=1,A$2:A$13,A$2:A$13<=E$7)*1&LOOKUP(ROW($2:$13),ROW($2:$13)/(B$2:B$13<>""),B$2:B$13)&C$2:C$13&D$2:D$13,)=ROW($1:$12)))
留言
張貼留言