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

§ì«ü©w°Ï¶¡«ü©w®Æ¸¹¼Æ¶q

§ì«ü©w°Ï¶¡«ü©w®Æ¸¹¼Æ¶q

½Ð°Ý

«ç»ò³]¤½¦¡§ì3/20~4/21°Ï¶¡  «ü©w XXX®Æ¸¹ªº¼Æ¶q?

§Úª¾¹D¼Ï¯Ã¥i¥H  ¤£ª¾¹D¦³¨S¦³¥Î¤è«Kªº¤½¦¡©O? :L

¦^´_ 1# jhwish

=sumproduct((¤é´Á½d³ò>=ªì©l¤é´Á)*(¤é´Á½d³ò<=µ²§ô¤é´Á)*(®Æ¸¹½d³ò=«ü©w®Æ¸¹))

TOP

¸Õ¹L¤F  ÁÙ¬O³£¶Ç¦^0

¯à¤£¯àÀ°§Ú¸Õ¸Õ©O?

ÀɮפW¶Ç¤F

²£½uª««~®w¦s²M³æ.rar (12.68 KB)

§Úªº¤À­¶Sheet2ªºF15­n¶Ç¦^3/20/13~4/21/13°Ï¶¡ CN-045AA (®Æ¸¹¦WºÙ)»â¶i¼Æ¶qªº¥[Á`

¦b³Â·Ð§A ~"~ ·P¿E¤£ºÉ

TOP

¦^´_ 3# jhwish

C15Àx¦s®æ
  1. =SUMPRODUCT((®w¦s©ú²Óªí!$A$4:$A$1000>=DATE(2013,COLUMN(A1)-1,21))*((®w¦s©ú²Óªí!$A$4:$A$1000<=DATE(2013,COLUMN(A1),20)))*(®w¦s©ú²Óªí!$D$4:$D$1000=$B15)*®w¦s©ú²Óªí!$G$4:$G$1000)
½Æ»s¥N½X
¤U©Ô¥k©Ô
¥t¥~§Aªº°_©l¤é´Á©M³Ì«á¤é´Á©Ç©Çªº¡A¥H4¤ë¨Ó»¡¡AÀ³¸Ó¬O3/21~4/20¡A¦Ó¤£¬O3/20~4/21§a¡A¦]¦¹§Ú¤½¦¡¨Ï¥Îªº¬O«eªÌ   

²£½uª««~®w¦s²M³æ_sol.png
2013-4-30 00:05

TOP

¦^´_ 4# Bodhidharma

·PÁÂ!²×©ó¥i¥H¥Î¤F!

~"~ °Ý¤F¦n¦h¤H³£¤£·|

¹ï¤F XD §A¯uÁo©ú   §Ú¤é´Á¯uªºKEY¿ù¤F

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD