ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¤ë¥÷¥[Á`

¤ë¥÷¥[Á`

¦pªG§ÚEXCEL°O¿ýµÛ50¶µ¤uµ{¡A¨ä¤¤¦b¬Y­ÓÄæ¦ì°O¿ýµÛ§¹¤u¤é´Á(¨Ò¡G12¤ë20¤é)¡A¨º¸Ó¦p¦ó²Î­p¦U¤ë¥÷§¹¤uªº¥ó¼Æ©O¡H¡H

°²³]§¹¤u¤é´Á¦bHÄæ,
K2=sumproduct((h$2:h$51<=today())*(month(h$2:h$51)=row(1:1)))
©¹¤UCOPY ¨ìK13

TOP

°²³]§¹¤u¤é´Á¦bHÄæ,
K2=sumproduct((h$2:h$51
ANGELA µoªí©ó 2011-12-20 10:03



¦p¤@¤ë¦bK2Äæ¦ì¡A¨Ì§Ç©¹¤U½Æ»s¤½¦¡¨ìK13¡A¦ý1¤ë¬O©|¥¼¦³¸ê®Æ¶ñ¤J¡A¦ý¸ÓÄ欰¤°»ò¤w¸g¦³²Î­p¼Æ¦r¤F¡H

TOP

¤W¶ÇÀÉ®×,§_«h¥u¬OÂû¦PÀnÁ¿,½M¤lºN¶H,

TOP

A1~A50¬°¤é´Á
    =SUMPRODUCT(--(TEXT($A$1:$A$50,"yym")="11"&ROW(1:1)),--(TEXT($A$1:$A$50,"yym")="11"&ROW(1:1)))

TOP

¦^´_ 5# register313

¤£ª¾³o¤½¦¡¤À§O¥Nªí¤°»ò·N«ä©O?¥i§_¸Ñ´b©O...

TOP

        ÀR«ä¦Û¦b : ­n¥Î¤ß¡A¤£­n¾Þ¤ß¡B·Ð¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD