excel¥i§_¦Û°Ê§PÂ_¥[Á`¤ë¸ê®Æ
- ©«¤l
- 37
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 176
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-6-22
- ³Ì«áµn¿ý
- 2014-1-16
|
excel¥i§_¦Û°Ê§PÂ_¥[Á`¤ë¸ê®Æ
¥»©«³Ì«á¥Ñ momowu ©ó 2010-6-25 01:35 ½s¿è
½Ð±Ð¦U¦ì¥ý¶i
excel¬O§_¥i§PÂ_¤ë¥÷¥[Á`
¨Ò¦p
·í¤¤ë¥÷À禬³ø§i¥X¨Ó,
¥i¥Hª¾¹D1-5¤ë¥÷²Öp¸ê®Æ,
¦Ó¤£·|²Öp¦Ü§ó¤§«eªº¦~¥÷¤§¤ë¥÷©O,ÁÂÁÂ
¦p¤U¹Ï
[attach]1422[/attach]
¥un´¡¤Jª«¥óªº¤è¦¡³£¥¢±Ñ,¤W¶Ç¥L»¡OK,´N¬On´¡¤J©«¤l¤º®e¤¤,ºô¶´NÅܱo¤@¤ùªÅ¥Õ.....
¼È®É¥Î§K¶OªÅ¶¡¸Õ¸Õ,¯u¬Osorry |
|
|
|
|
|
|
- ©«¤l
- 65
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 120
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-15
- ³Ì«áµn¿ý
- 2010-7-16
|
¦^´_ 1# momowu
¨S¦³¹Ï¡A½Ð¦A½T»{¡C |
|
|
|
|
|
|
- ©«¤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
- 130
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 162
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-5-7
- ³Ì«áµn¿ý
- 2011-7-16
|
¸g±`°µ³o¼Ë³øªí
¦~/¤ë À禬
98/10/31 123
98/11/30 234
98/12/31 341
99/01/31 34 ...
gong µoªí©ó 2010-6-24 21:25
ª©¥D¤ÓÀu¤F
¤p§Ì¤]´£¨Ñ¤@Ó
°}¦C¤½¦¡
{=SUM((YEAR(A2:A18)=MAX(YEAR(A2:A18)*(B2:B18>0)))*B2:B18)} |
|
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡
|
|
|
|
|
- ©«¤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
- 1180
- ¥DÃD
- 204
- ºëµØ
- 0
- ¿n¤À
- 1051
- ÂI¦W
- 0
- §@·~¨t²Î
- Mac.OS10.6
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2012-9-19
|
¦^´_ 6# gong
ÁÂÁª©¥D
±zªº·s¤½¦¡´N¾A¥Î¼Ó¥Dªºµo¤å
¥i¥H½Ð°Ý
±zì¨Ó¼gªºB20ªº¤½¦¡
¬On©ñ¦bþÓÀx¦s®æªº¤½¦¡?
ÁÂÁ±z.. |
|
|
|
|
|
|
- ©«¤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
|
|
|
|
|
- ©«¤l
- 37
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 176
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-6-22
- ³Ì«áµn¿ý
- 2014-1-16
|
¥»©«³Ì«á¥Ñ momowu ©ó 2010-6-26 09:17 ½s¿è
ÁÂÁª©¥DÌ,¤wÀò±o¸Ñ¨M !! |
|
|
|
|
|
|