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

[µo°Ý] ¨Ï¥ÎINDIRECT,¤½¦¡­n¦p¦ó¤U©Ô½Æ»s

[µo°Ý] ¨Ï¥ÎINDIRECT,¤½¦¡­n¦p¦ó¤U©Ô½Æ»s

±z¦n
¦pªþ¥ó
§Ú§Æ±æ´¡¤J¾ã­ÓCÄæ®É¡A¥i¥HÅýB2ªº¤½¦¡¤£·|¶]±¼¡A§Ú¨Ï¥Î SUM(INDIRECT("C2:D2"))
¦ý§Ú«o¨S¿ìªk¤U©Ô¤½¦¡
³Â·Ð¦U¦ì¨ó§U»P«ü±Ð
ÁÂÁÂ!!

Book3.rar (6.27 KB)

¦^´_ 13# zz5151353

³o­Ó¤½¦¡¦n
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

B2 ¤½¦¡
=SUM(INDIRECT("RC3:RC4",))
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

À³¸Ó¬O¼Ó¤W»¡ªº³o¼Ë¨S¿ù¡A¸Õ¤F¤@¤U¡Amei¤j¸òp212³Ì«áªº¤½¦¡¡A¤G­Ó³£«Ü¦n§r¡A
¬Ý³ßÅw­þ¤@ºØ¤è¦¡´N¥Î­þ¤@ºØ¤è¦¡§a¡C

TOP

ªO¥D¤j·§¬O¨C¦¸¤p¦Ò¥ÑCÄæ´¡¤J¡A¤p¦Ò¦¨ÁZ«h¬O²Î­p³Ìªñ2¦¸¦¨ÁZ¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_  pupai
³o¼Ë¦p¦ó¡H
SUM(INDIRECT("C"&ROW(2:2)&""&ROW(2:2)))
p212 µoªí©ó 2013-10-14 11:47



    OFFSET ¨ç¼Æ¨Ã¤£·|¯uªº²¾°Ê¥ô¦óÀx¦s®æ©Î§ó§ï¿ï©w½d³ò¡A¦Ó¥u¬O¶Ç¦^¹Bºâ«áªº°Ñ·Ó¦ì§}
ÁÂÁÂ

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2013-10-14 11:51 ½s¿è

¦^´_ 5# mei27
mei27 ¤j¡G
±z¦n¡I
´¡¤J¾ã­ÓCÄæ®É¡A¤½¦¡=SUM(OFFSET(B2,0,1,1,2))·|²§°Ê¡A±o¤£¨ì¥¿½Tµ²ªG¡C

TOP

¦^´_ 6# pupai
³o¼Ë¦p¦ó¡H
SUM(INDIRECT("C"&ROW(2:2)&":D"&ROW(2:2)))

TOP

¦^´_  pupai

³o¼Ë¤l¬O§A»Ý­nªºµ²ªG¶Ü¡H
=SUM(OFFSET(B2,0,1,1,2))
mei27 µoªí©ó 2013-10-14 11:40



    ­ì¨Ó¬OOFFSET
ÁÂÁ«ü±Ð

TOP

¦^´_  pupai
½Ð°Ý±z­nªº¬O¤°»ò¡H
¤£µMB2Àx¦s®æª½±µ¥ÎSUM(C22)¤£´N¥i¥H¡H
­Y´¡¤J¾ã­ÓCÄæ¡AB2Àx¦s®æ¤½¦¡ ...
p212 µoªí©ó 2013-10-14 11:35



    §Ú¨Ï¥Î¤F    SUM(INDIRECT("C2:D2"))
INDIRECT¥i¥HÅý·s¼WÄæ¦ì®É¤£­n¦Û°Ê§ïÅܹBºâ¦¡
¦ý¦³¤@­Ó¯ÊÂI¡¨¨S¿ìªk¤U©Ô¤½¦¡¡¨
³Â·Ð¦U¦ì¨ó§U»P«ü±Ð
ÁÂÁÂ!!

TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD