«ö¤ë¥[Á`

myleoyes

¦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!!

register313

¦^´_ 1# myleoyes

A81=SUM(OFFSET(B70:C70,0,(MONTH(TODAY())-1)*2,,),OFFSET(D68:E69,0,(MONTH(TODAY())-1)*2,,))

myleoyes

¦^´_ 2# register313
«e½ú!ÁÂÁÂ!!
        ¥t¨D¤@¤½¦¡¦pªGA81¬O­n¦A¨C¤ë¥÷ªº³Ì«á¤@¤Ñ¤~Åã¥Ü¥X
       ½Ð°Ý³o¤½¦¡¤S¬°¦ó?½Ð¦A³Â·Ð½ç±ÐÁÂÁ¦A¤T!!

Hsieh

¦^´_ 3# myleoyes

=IF(MONTH(TODAY())<>MONTH(TODAY()+1),SUM(OFFSET(A68,,MATCH(MONTH(TODAY()),$68:$68,0)-1,2,2),OFFSET(A68,2,MATCH(MONTH(TODAY()),$68:$68,0)-3,,2)),"")

myleoyes

¦^´_ 4# Hsieh
°¸¹³«e½ú!ÁÂÁ¦A¤T!!

myleoyes

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

register313

¦^´_ 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,,)),"")

Hsieh

¦^´_ 6# myleoyes

4¤ë§ä¤£¨ì·íµM¥X¿ù

c_c_lai

§Ú¦³¨Ç¤£¸Ñ¤§³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

register313

¦^´_ 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