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

[µo°Ý] ¦p¦ó¨Ì¤ë¥÷²Î­p¼Æ¶q¡H

[µo°Ý] ¦p¦ó¨Ì¤ë¥÷²Î­p¼Æ¶q¡H



½Ð°Ý¦U¦ì¤j­ô¡B¤j©n­Ì
¦V¤W­±³o¼ËªºªºEXCELªí®æ¡A¦pªG§Ú­n¨Ì¤ë¥÷²Î­p¦b¥t¤@±i¤u§@ªí¡AÀ³¸Ó¥Î¬Æ»ò¤½¦¡¡H
¨Ò¦p
¤é´Á¥i¯à¦³1/1~2/28¡A¦ý§Ú­nªº¬O¤@¤ë¥÷¸Ì©Ê§OÁ`­p¦h¤Ö¤H(¤@¤ë¥÷¨k¦h¤Ö¡H¤k¦h¤Ö¡H)¡A«á­±¥H¦¹Ãþ±À¡C
©Ò¥H®æ¤l¸Ì³£¬O¶ñ¼g¼Æ¶q¡A³Â·Ð­þ¦ì¤j¤j±Ð§Ú¤@¤U¡A¸Ó¦p¦ó³]©w¡C
·P®¦!

¦^´_ 1# danny7014

¤ë¥÷²Î­p¼Æ¶q.rar (13.45 KB)




   
¤£ª¾¹D¬O¤£¬O«ü³o¼Ë??
sheet2
B2=IF(SUMPRODUCT(N(MONTH(Sheet1!$B$5:$B$14)=ROW(1:1)),(Sheet1!$C$5:$C$14))=0,"",SUMPRODUCT(N(MONTH(Sheet1!$B$5:$B$14)=ROW(1:1)),(Sheet1!$C$5:$C$14)))
C2=IF(SUMPRODUCT(N(MONTH(Sheet1!$B$5:$B$14)=ROW(1:1)),(Sheet1!$D$5:$D$14))=0,"",SUMPRODUCT(N(MONTH(Sheet1!$B$5:$B$14)=ROW(1:1)),(Sheet1!$D$5:$D$14)))
¦V¤U©Ô½Æ»s

TOP

·PÁÂfantersy ¤j¤jªº¦^ÂСA¤£¹L§Ú¦³¤@ÂI¬Ý¤£À´¤½¦¡¡A¥i§_½Ð±z¦A¸Ñ»¡¤@¤U¡AÅý§Ú§ó¤F¸Ñ¤@¤U±zªº«ä¸ô¡A·P®¦!!

TOP

¦^´_ 3# danny7014

SUMPRODUCT(N(MONTH(Sheet1!$B$5:$B$14)=ROW(1:1)),(Sheet1!$C$5:$C$14))
º¡¨¬1¤ë
¥B¬°¨k¥Íªº¼Æ¶q¦³¦h¤Ö(¨k¥Íªº½d³ò¦bSheet1!$C$5:$C$14    ¤k¥Íªº½d³ò¬OSheet1!$D$5:$D$14)
N¥u¬O§âTRUEÂন1

MONTH(Sheet1!$B$5:$B$14) ->±N¿é¤Jªº¤é´Á¥u¨ú¤ë¥÷
ROW(1:1)=1->¤]´N¬O1¤ë¥÷  ¤U©Ô·|Åܦ¨ROW(2:2)=2¤]´N¬O2¤ë¥÷
¦Ü©ó¦³¥[IF
IF(SUMPRODUCT(N(MONTH(Sheet1!$B$5:$B$14)=ROW(1:1)),(Sheet1!$C$5:$C$14))=0,"",SUMPRODUCT(N(MONTH(Sheet1!$B$5:$B$14)=ROW(1:1)),(Sheet1!$C$5:$C$14)))
¦]¬°¤£º¡¨¬©Î§ä¤£¨ì±ø¥ó®É·|Àx¦s®æ·|±a¼Æ¦r0
§Ú¥u¬O¥ÎIF¥h§P©w·í¬°0®ÉÅã¥Ü¬°ªÅ¥Õ
¤£¬Oªº¸Ü´N°õ¦æ¤½¦¡
^^

TOP

·PÁ§Aªº¥Î¤ß¸Ñ»¡¡A·P®¦

TOP

        ÀR«ä¦Û¦b : ¦Y­W¤F­W¡B­WºÉ¤Ü¨Ó¡A¨ÉºÖ¤FºÖ¡BºÖºÉ´d¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD