ªð¦^¦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ÄÝ©ó"¯}"ªº¦¸¼Æ

¦Û¤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 : ¤£­n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µL­­ªº¥i¯à¡C
ªð¦^¦Cªí ¤W¤@¥DÃD