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

¦p¦ó¥Îindirect¨ç¼Æ³sµ²¦Ü¦U¤u§@ªí§@¥[Á`

¦p¦ó¥Îindirect¨ç¼Æ³sµ²¦Ü¦U¤u§@ªí§@¥[Á`

¨C¤ë¶O¥Î­pºâ.rar (5.34 KB) ­n¦p¦ó¥Îindirect¨ç¼Æ³sµ²¦Ü¦U¤u§@ªí§@¥[Á`©O
±ý¨D¥X"²Î ­p"¤u§@ªí¤ºªºB2­È...
joyce

=SUMIF(INDIRECT("'"&$B$1&"'!A:B"),$A2,INDIRECT("'"&$B$1&"'!B:B"))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

©Òª¾INDIRECT¨ç¼Æ¸I¨ì¸ó¤u§@ªí®É,¨ä³W«h¬OINDIRECT(¤u§@ªí¦W&!°Ñ·Ó¦ì¸m)...
¤£À´¤½¦¡¤¤¬°¦ó­n¥[¦¹¬qindirect(""&¦Ó¤£¬Oª½±µindirect($B$1&"'!A:B")
=SUMIF(INDIRECT("'"&$B$1&"'!A:B"),$A2,INDIRECT("'"&$B$1&"'!B:B"))
joyce

TOP

¼Æ¦r«¬ºAªº¤u§@ªí¦WºÙ¥[¤W³æ¤Þ¸¹
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¤F¸Ñ,©Ò¥H»¡­Y¬O¤å¦r«¬ºAªº¤u§@ªí,´N¤£¥Î¥[³æ¤Þ¸¹Åo...ÁÂÁ¦^ÂÐ
joyce

TOP

­n¦p¦ó¥Îindirect¨ç¼Æ³sµ²¦Ü¦U¤u§@ªí§@¥[Á`©O
±ý¨D¥X"²Î ­p"¤u§@ªí¤ºªºB2­È...
leiru µoªí©ó 2011-7-20 13:30


­É¥Î¼Ó¥Dªº¸ê®Æ®w¤@°Ý

°²³]¸ê®Æ§¨¤º¬O¦h¦~¥H¨Ó¦U¤ë¥÷ªº¸ê®Æ¡]¨Ò¦p¡G±q¢¸¢¶¦~¢°¤ë¡ã¢°¢¯¢¯¦~¢µ¤ë¥÷¬°¤îªº§¹¾ã¸ê®Æ¡^¡A¨º»ò§Ú¦pªG·Q¦b²Î­pªí¤º±oª¾¬Y¦~«×Á`­p¡]¨Ò¦p¡G¢¸¢·¦~«×¢°¡ã¢°¢±¤ëªº¦X­p¡^¡A¤S¸Ó¦p¦ó³]¤½¦¡©O¡H·PÁ½ç±Ð¡I

TOP

¸Ó¦~«×ÀÉ®×¥²¶·¬O¶}±Òªºª¬ºA
©Ò¥H¡A°ò¥»¤W­n³sµ²¨ä¥LÀɮר䣾A¦X¥HÅܼƧ@¬°¬d¸ß¨Ó·½
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

­è¦n¥¿¦b·Ð´o¦p¦ó¸Ñ¨M¦U¤u§@ªí¥[Á`¡A
ÁÂÁ±zªº¤À¨É¡A¨ü¥Î«Ü¦h¡C

TOP

·PÁÂ,­è¦n»Ý­n¥Î¨ì
¥ý¸Õ¬Ý¬Ý

TOP

        ÀR«ä¦Û¦b : §g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí ¤W¤@¥DÃD