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

¦P¤@¤H¶µ¤Uªº¼Æ¦r¥[Á`

¦P¤@¤H¶µ¤Uªº¼Æ¦r¥[Á`

¦pÀɮתí¤@¬°¾Ç¥Í¦U¶µ¥Øªº«Ýú¶O¥Î¡A§Ú·Q­n§â¦U¾Ç¥Í«Ýú¶O¥Î¦Û°Ê¥[Á`¦Üªí¤G¡Aµ{¦¡­n¦p¦ó¼g¡H
½ÐÀ°À°¦£¡IÁÂÁ¡I LOO.zip (1.63 KB)

¥»©«³Ì«á¥Ñ mistery ©ó 2010-12-16 12:02 ½s¿è

¥Î SUMIF ¨ç¼Æ
¦bÀx¦s®æ F3 ¿é¤J¥H¤U¤½¦¡  µM«áª½±µ¤U©Ô§Y¥i
=SUMIF($A$3:$C$11,E3,$C$3:$C$11)


TOP

·PÁ´£¨Ñ¡I
¨º¦pªG¤@­Ó¯Z¤W¦³¤T¡B¥|¤Q­Ó¾Ç¥Í¡A­n¦bªí¤GªºEÄæ¥ý§â¤í¶Oªº¾Ç¥Í¿z¿ï¥X¨Ó¡A¦A­pºâ¶O¥ÎÁ`ÃB­n¦p¦ó¥Î¨ç¼Æ³]©w¡H

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-12-16 13:51 ½s¿è

¼Ï¯Ã¤ÀªRªí¬O¸û¦nªº¿ï¾Ü
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

³o¬O§Ú­×§ï«áªºµ²ªG¡Aªí¤G¬O·J¾ãªí¤@¨C­Ó¤H«Ýú¶O¥ÎÁ`ÃB¡A¬°¦ó¦bL6Àx¦s®æ·|¥X²{L2ªº­«ÂСA­n«ç»ò­×¡H

aa.zip (22.62 KB)

TOP

¦^´_ 5# banff


    L2=SUMIF($E$1:$F$20,E2,$F$1:$F$20)
¦V¤U½Æ»s
«Øij¨Ï¥Î¼Ï¯Ã¤ÀªRªí·|¦n¤@ÂI
aa.zip (23.5 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

«Ü·PÁ´£¨Ñªº«Øij¡A¨ä¹ê§Ú¹ï¼Ï¶s¤ÀªR¸òVB¤@ÂI·§©À³£¨S¦³¡A¤]¤£ª¾±q¦ó¤J¤â¡I

TOP

¦^´_ 7# banff

§A¨Ï¥Î¤½¦¡¤£¬O¤@¼Ë¤]¦³°ÝÃD?
­«ÂI¬O­n¥h¾Ç·|¥L¦Ó¤£¬O°kÁ×¥L
ªþ¥ó¤¤¤w¦³¼Ï¯Ã¤èªk§A¥i°Ñ¦Ò¬Ý¬Ý
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD