ML089

«e­Ó¤ë³Ì«á6¤Ñ

BV48 =IF(COLUMN(A1)>6,"",$D$48-7+COLUMN(A1))
BV49 =TEXT(BV61,"[$-804] aaa;;;")

ML089

¦^´_ 5# jackson7015

D50 ®æ¦¡¤Æ¤½¦¡
=SUM(COUNTIF(OFFSET(D50,,,,-MIN(7,COLUMN()-3)),{5,6,11}))

ML089

¦^´_ 7# jackson7015

§Ñ°O¬O¥Î¦b®æ¦¡¤Æ¤½¦¡¤£¯à¥Î {5,6,11}
°Ñ¦Ò­ã¤j¤½¦¡§ï¬° CHOOSE(ROW(1:3),5,6,11)¡A³o¬O«Ü´Îªº¤èªk¡C

§AªºEXCEL¸ê®Æ
D48:AG48 ¬° 2007/9/1 : 2007/9/30
BV48:CD48 ¬° 2007/9/22 : 2007/9/30

¬O§_À³¸Ó§ï¬°
BV48:CE48 ¬° 2007/8/22 : 2007/8/31

ML089

¦^´_ 11# jackson7015

D48:AG48 ¬° 2007/9/1 : 2007/9/30
BV48:CE48 ¬° 2007/8/22 : 2007/8/31 ­ìÀÉ®×­n­×¥¿


D50®æ¦¡¤Æ¤½¦¡¡A¾Ü¨ä¤@¨Ï¥Î   
=COUNT(0/(($D$48:$CE$48<=D$48)*($D$48:$CE$48>D$48-7)*($D50:$CE50=CHOOSE(ROW($1:$3),5,6,11))))
=COUNT(0/(($D$48:$CE$48<=D$48)*($D$48:$CE$48>D$48-7)*(($D50:$CE50=5)+($D50:$CE50=6)+($D50:$CE50=11))))

ML089

¦^´_ 13# jackson7015


    ´ú¸Õ«e¤ë¥÷ªº§ó°Ê¯Zªí«á¡A¨S¦³³s°Ê¨ì·í¤ë¥÷ªº§PÂ_¤½¦¡
³o¥y¤£¬O«ÜÀ´

ML089

¦^´_ 15# jackson7015

$BU50¡G¤W¤ë¤u§@¤Ñ¼Æ
D:I »Ý­n¤W­Ó¤ë¸ê®Æ¡AJ¥H«á´N¤£¥Î¤F¡A
®æ¦¡¤Æ±ø¥óªí¤¤¦h¥[¤F
D50=IF(OR(LEN(D$48)<1,LEN($BU50)<1),TRUE,FALSE)
·|¤£·|¦³¤Ï®ÄªG¡A·í LEN($BU50)<1 ®É¡AJ¥H«áªº§PÂ_¬O§_³Q¼vÅT