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

[µo°Ý] ·J¾ã¦h­Ó¤u§@ªí¬Û¦PÄæ¦ì¦¨¤@±i·sªº¤u§@ªí

[µo°Ý] ·J¾ã¦h­Ó¤u§@ªí¬Û¦PÄæ¦ì¦¨¤@±i·sªº¤u§@ªí

§Ú¬O¤p¾Ç¥Í
½Ð¦U¦ìÀ°¦£
¦p¦ó·J¾ã¦h­Ó¤u§@ªí¬Û¦PÄæ¦ì¦¨¤@±i·sªº¤u§@ªí?
ÁÂÁÂ

§Ú¥Î=indirectªº¤è¦¡¤Þ¥Î¤£¦P¬¡­¶Ã¯¤£¦PÄæ¦ì¨ì·sªº¤u§@ªí
¨C¶}±Ò¤Q­Ó¬¡­¶Ã¯¦A§â¥L½Æ»s²¾¶}
¤£¬O«Ü§Ö,¦ý¦³¸`¬Ù¤@¨Ç®É¶¡
»Ý­n¦A¦hªá¤@ÂI®É¶¡¾Ç²ß
ÁÂÁÂÀ°¦£

TOP

§Ú¬O¥Î"="
§â·s¤u§@ªí¬[ºc°_¨Ó
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¤£¦n·N«ä
´y­zªº¤Ó¼Ò½k¤F
§Ú¦³¤@¥÷¼Ð·Ç®æ¦¡ªº¹q¤lªí³æ
¨C¤@¥÷¹q¤lªí³æ¤À§O¦s¦b¤£¦PªºÀÉ®×(ÀɦW¤£¦P¡A¤u§@ªí¦WºÙ¤]¤£¤@¼Ë)
°²³]§Ú­nÂ^¨ú¤£¦PÀɮפ£¦P¤u§@ªí¤Uªºcell(2,1),cell(5,2),cell(7,2)...
¨ì¤@­Ó·sªº¤u§@ªí¤U
¤£¦PÀɮפ£¦P¤u§@ªí¤U¬Û¦Pªºcell©ñ¦b·s¤u§@ªíªº¦P¤@Äæ¨Ì§Ç±Æ¦C
³o¼Ë­n¦p¦óÂ^¨ú©O?

TOP

=SUM(Sheet1:SheetX!A1)
sheet1«ü²Ä¤@±i¤u§@ªí¦WºÙ
sheetX«ü³Ì«á¤@±i¤u§@ªí¦WºÙ

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD