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

¬Û¦PÄæ¦ìªº­È_ªº¼Æ¶q_¥[Á`

¬Û¦PÄæ¦ìªº­È_ªº¼Æ¶q_¥[Á`

Dear ¤j¤j~

¦³¤@¨ç¼Æsumproduct  ¬O¥Î¤T­Ó±ø¥ó¦¡" ²Õ¦¨ªº

¥i¥H§ä¥X¨â­ÓÄæ¦ì¬Û²Åªº­ÈµM«á¬Û¥[~~  
§ÚÀ³¸Ó¨S¦³»¡¿ù§a?  ¦pªG»¡¿ù½Ð¤£§[«üÂI~!!

¤pªº§Ú·Q­n¥u¤ñ¹ï¤é´Á µM«á§â¦P¤@¤Ñ¤é´Á¸Ì­±ªº¼Æ¶q¬Û¥[~

sheet"all!" ¬O 2010/10/18~10/27 ªº¼Æ¶q~ ¦³­«½Æ¤é´Á~

¨ºsheet"daily!" ´N¬O§Æ±æ¯à§â10/18~10/27 ¨C¤Ñ·í¤éªºÁ`¶q¬Û¥[~

½Ð°Ý¤j¤j~  ¬O¥Î if sum ¶Ü?

ÁÂÁ¤j¤jªº«ü±Ð~

¤é´Á¬Û²Å¥[Á`~.rar (7.12 KB)

¤é´Á¬Û¦P¥[Á`

¥»©«³Ì«á¥Ñ GBKEE ©ó 2010-11-25 17:21 ½s¿è

¦^´_ 1# webbliu
Daily!B2=SUMIF(October!$A$2:$A$65536,Daily!A2,October!$B$2) ¤U©Ô

TOP

¦^´_ 2# GBKEE


    ÁÂÁ¤j¤jªº«ü¾É!

TOP

¦^´_ 3# webbliu
¼Ï¯Ã¤ÀªRªí²³æ¸Ñ¨M
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


    ÁÂÁª©¥Dªº«ü¾É~

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD