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

«ö¤ë¥[Á`

«ö¤ë¥[Á`

¦U¦ì«e½ú§A­Ì¦n!
          «e½ú!!
           A81=IF(MONTH(TODAY())=MONTH(E81),SUM(D68,D69:E69,B70:C70),IF(MONTH(TODAY())=MONTH
(G81),SUM(F68,F69:G69,D70:E70),""))
           °ÝÃD¦pªþÀÉ»¡©ú
           ½Ðª¾¹Dªº«e½ú,¤£§[½ç±ÐÁÂÁ¦A¤T!!

Leo24.rar (7.72 KB)

¦^´_ 13# register313
«e½ú¨¯­WÅo!ÁÂÁ¦A¤T!!

TOP

¦^´_ 12# myleoyes

¤W¤@­Ó¤½¦¡¨ä¹ê°½Ãi¤@ÂI,¥[¤F6­ÓÀx¦s®æ

=IF(MONTH(TODAY())<>MONTH(TODAY()+1),SUM(OFFSET(D68,0,(MONTH(TODAY())-1)*2,,),OFFSET(D69:E69,0,(MONTH(TODAY())-1)*2,,),OFFSET(B70:C70,0,(MONTH(TODAY())-1)*2,,)),"")

TOP

Leo24-2.gif Leo24-1.gif Leo24-2.gif Leo24-1.gif ¦^´_ 5# myleoyes
¤£¦n·N«äÂsÄý¾¹©Ç©Çªº­Y¦³­«½Æ½Ð¨£½Ì
register313«e½ú!§Aªº¤½¦¡¦³»~¦pªþÀÉLeo24-1
   °¸¹³«e½ú!¤£¬O³o¼Ë¤l¦pªþÀÉLeo24-2½Ð¤U²¾ÀÉ®×
   ¤é´Á¬°3¤ë31¤éµL»~
   ½Ð¨â¦ì¹³«e½ú¦A¨¯­WÅo!¤£§[½ç±ÐÁÂÁ¦A¤T!!

TOP

ÁÂÁ±z¡I ¤£¸g¤@¨Æ¤£ªø¤@´¼¡C

TOP

¦^´_ 9# c_c_lai

OFFSET(B70:C70,0,(MONTH(TODAY())-1)*2,,)

­ì¥[Á`¤§Àx¦s®æ¬°B70:C70
­Y¤µ¤é¤ë¥÷¬°1¤ë ,(MONTH(TODAY())-1)*2=(1-1)*2=0, B70:C70¤§Äæ¦ì°¾²¾0Äæ  => ¥[Á`¤§Àx¦s®æ¬°B70:C70
­Y¤µ¤é¤ë¥÷¬°2¤ë ,(MONTH(TODAY())-1)*2=(2-1)*2=2, B70:C70¤§Äæ¦ì°¾²¾2Äæ  => ¥[Á`¤§Àx¦s®æ¬°D70:E70
­Y¤µ¤é¤ë¥÷¬°3¤ë ,(MONTH(TODAY())-1)*2=(3-1)*2=4, B70:C70¤§Äæ¦ì°¾²¾4Äæ  => ¥[Á`¤§Àx¦s®æ¬°F70:G70

TOP

§Ú¦³¨Ç¤£¸Ñ¤§³B­n½Ð±Ð¦U¦ì«e½ú­Ì(¤Å¨£¯º)¡G
=IF(MONTH(TODAY())<>MONTH(TODAY()+1),SUM(OFFSET(B70:C70,0,(MONTH(TODAY())-1)*2,,),OFFSET(D68:E69,0,(MONTH(TODAY())-1)*2,,)),"")
¤¤¡A¬°¦ó(MONTH(TODAY())-1)*2,,)­n­¼¥H¤G©O (*2)¡H
ÁÂÁ±z¡I

TOP

¦^´_ 6# myleoyes

4¤ë§ä¤£¨ì·íµM¥X¿ù
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# myleoyes


=IF(MONTH(TODAY())<>MONTH(TODAY()+1),SUM(OFFSET(B70:C70,0,(MONTH(TODAY())-1)*2,,),OFFSET(D68:E69,0,(MONTH(TODAY())-1)*2,,)),"")

TOP

¦^´_ 5# myleoyes
°¸¹³«e½ú!¤½¦¡¦³»~²Ä68¦Cªº¼Æ¦r³£¤£¯à­×§ï
¦pªþ°Êµe½Ð¦A­×§ïÁÂÁ¦A¤T!!

Leo24.gif (247.6 KB)

Leo24.gif

TOP

        ÀR«ä¦Û¦b : ºÉ¦h¤Ö¥»¥÷¡A´N±o¦h¤Ö¥»¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD