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

[µo°Ý] ½Ð°Ý¦p¦ó­pºâ³ÌªñN¤ÑªºÁ`©M©O¡H(¤w¸Ñ¨M)

[µo°Ý] ½Ð°Ý¦p¦ó­pºâ³ÌªñN¤ÑªºÁ`©M©O¡H(¤w¸Ñ¨M)

¥»©«³Ì«á¥Ñ alhuang88888 ©ó 2011-12-6 10:25 ½s¿è

¦pªG§Ú¦³¨â¦æªº¸ê®Æ¡A¤@¦æ¬O¤é´Á¡A¤@¦æ¬O¼Æ¦r¡A§Ú­n¦p¦óªí¥Ü³ÌªñN¤ÑªºÁ`©M©O¡H
¤ñ¦p¸ê®Æ¦p¤U
¤é´Á       ¼Æ­È
12/4      10
12/3      20
12/3      20
12/3      10
12/1      40
12/1      40
12/1      40

°²­Y¤µ¤é¬O12/4¡A§Ú­n­pºâ³Ìªñ3¤Ñ¤]´N¬O12/2~12/4ªº¼Æ­ÈÁ`©M¡A¦]¬°ªí®æ¤¤¨S¦³12/2ªº¼Æ­È¡A©Ò¥HÁ`©M¬O60¡C
³Â·Ð¤F~

§Ú¦Û¤v¸Õ¥X¨Ó¤F¡A³ÌªñN¤Ñªº¤èªk¡A¦pªG¬O7¤Ñªº¤U¤èÂŦâ°Ï´N­n±a6¡A5¤Ñªº´N­n±a4¡C¿é¤J§¹­nShift+Ctrl+Enter
=SUM(IF((TODAY()-A1:A7)<N-1,B1:B7))

¦pªG¦³¨ä¥¦¤èªk¤]½Ð¦h«Øij¡AÁÂÁÂ~

TOP

=SUMIF(A1:A7,">="&TODAY()-3,B1:B7)

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD