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

[µo°Ý] ½Ð°ÝÂù±ø¥ó²Î­p°ÝÃD?

[µo°Ý] ½Ð°ÝÂù±ø¥ó²Î­p°ÝÃD?

½Ð°Ý¦U¦ì«e½ú
§Ú¦³¤@­Óexcel¦p¤U
§Ú·Q­n²Î­p¡uµo¥Í¤é¡v¦b2013/12/31¥H«e¡uÃþ§O¡vÄÝ©ó"¯}"ªº¦¸¼Æ
¹Ï¤ù 1.JPG
2014-3-19 09:53

¦Û¤v§Ë¤F¦n¤[´N¬O§Ë¤£¦n

ªþ¤WÀÉ®×
±±ºÞ¶i«×ªí.zip (12.54 KB)
°Ê©À¦¨¦]¿n¦]¦¨ªG by huijuang

¥»©«³Ì«á¥Ñ p212 ©ó 2014-3-19 11:50 ½s¿è

¦^´_ 1# huijuang
1¡B¿ï¨úG6:G72»PI6:I72¡A«öCtrl+Shift+F3¡A¿ï¾Ü¡u³»ºÝ¦C¡v¬°½d³ò¦WºÙ¡C
2¡B¥ô¤@Àx¦s®æ¿é¤J¤@¯ë¤½¦¡
¡×SUMPRODUCT((µo¥Í¤é<=DATE(2013,12,31))*(Ãþ§O¡×"¯}"))
©Î
¡×SUMPRODUCT((µo¥Í¤é<DATE(2014,1,1))*(Ãþ§O¡×"¯}"))
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 2# p212
·PÁ«e½úªº¦^´_
­ì¨Ó§Ú¤@ª½§â2013/12/31³o­Ó§Ë¿ù¤F
©Ò¥H¤@ª½°µ¤£¥X¨Ó
°Ê©À¦¨¦]¿n¦]¦¨ªG by huijuang

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD