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

excel¥i§_¦Û°Ê§PÂ_¥[Á`¤ë¸ê®Æ

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]



¥u­n´¡¤Jª«¥óªº¤è¦¡³£¥¢±Ñ,¤W¶Ç¥L»¡OK,´N¬O­n´¡¤J©«¤l¤º®e¤¤,ºô­¶´NÅܱo¤@¤ùªÅ¥Õ.....
¼È®É¥Î§K¶OªÅ¶¡¸Õ¸Õ,¯u¬Osorry

¦^´_ 1# momowu


    ¨S¦³¹Ï¡A½Ð¦A½T»{¡C

TOP

¸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

TOP

¸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¥Í¬¡

TOP

¦^´_ 3# gong


    GONGª©¥D
¥i¥H½Ð°Ý±z
±zªºB20ªº¤½¦¡¤º®e
­n©ñ¦bMOMOWUÀÉ®×­þ­ÓÀx¦s®æ¸Ì?
¥i¥H½Ð±z«ü¾É¶Ü?
ÁÂÁÂ....
excel¬O§_¥i§PÂ_¤ë¥÷¥[Á`.rar (3.09 KB)

TOP

C3
=SUM(OFFSET($B3,,,MONTH($A3),))
©¹¤U½Æ»s
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 6# gong


    ÁÂÁª©¥D
±zªº·s¤½¦¡´N¾A¥Î¼Ó¥Dªºµo¤å
¥i¥H½Ð°Ý
±z­ì¨Ó¼gªºB20ªº¤½¦¡
¬O­n©ñ¦b­þ­ÓÀx¦s®æªº¤½¦¡?
ÁÂÁ±z..

TOP

¦^´_ 7# PD961A


    ¸ê®Æ±Æ¦C¤£¦P¤½¦¡¤£¯à³q¥Î
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ gong ©ó 2010-6-25 15:52 ½s¿è

¸ê®Æ¦p¤W­z
¤½¦¡©ñ¦bb20¬O§ÚÀH«K©ñ
¥u­n¤£©ñ¦ba1:b19¤§¤º³£¥i¥H±o¨ì¬Û¦Pµ²ªG
©ñ¦bc1¤]¥i¥H

Book1.rar (1.78 KB)

ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¥»©«³Ì«á¥Ñ momowu ©ó 2010-6-26 09:17 ½s¿è

ÁÂÁª©¥D­Ì,¤wÀò±o¸Ñ¨M !!

TOP

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD