excel¥i§_¦Û°Ê§PÂ_¥[Á`¤ë¸ê®Æ
- ©«¤l
- 455
- ¥DÃD
- 8
- ºëµØ
- 1
- ¿n¤À
- 480
- ÂI¦W
- 0
- §@·~¨t²Î
- WINS home
- ³nÅ骩¥»
- OFFICE XP
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥Âí
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2015-1-22
|
¸g±`°µ³o¼Ë³øªí
¦~/¤ë À禬
98/10/31 123
98/11/30 234
98/12/31 341
99/01/31 345
99/02/28 348
99/03/31 452
99/04/30 237
99/05/31 196
99/06/30
99/07/31
b20=SUM(OFFSET(B$1,MATCH(LOOKUP(2,1/($B$2:$B$19),$A$2:$A$19),$A$2:$A$19,0),,-MONTH(LOOKUP(2,1/($B$2:$B$19),$A$2:$A$19)))) |
|
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I
|
|
|
|
|
- ©«¤l
- 455
- ¥DÃD
- 8
- ºëµØ
- 1
- ¿n¤À
- 480
- ÂI¦W
- 0
- §@·~¨t²Î
- WINS home
- ³nÅ骩¥»
- OFFICE XP
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥Âí
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2015-1-22
|
C3
=SUM(OFFSET($B3,,,MONTH($A3),))
©¹¤U½Æ»s |
|
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I
|
|
|
|
|
- ©«¤l
- 455
- ¥DÃD
- 8
- ºëµØ
- 1
- ¿n¤À
- 480
- ÂI¦W
- 0
- §@·~¨t²Î
- WINS home
- ³nÅ骩¥»
- OFFICE XP
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥Âí
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2015-1-22
|
¥»©«³Ì«á¥Ñ gong ©ó 2010-6-25 15:52 ½s¿è
¸ê®Æ¦p¤Wz
¤½¦¡©ñ¦bb20¬O§ÚÀH«K©ñ
¥un¤£©ñ¦ba1:b19¤§¤º³£¥i¥H±o¨ì¬Û¦Pµ²ªG
©ñ¦bc1¤]¥i¥H |
-
-
Book1.rar
(1.78 KB)
|
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I
|
|
|
|
|