ªð¦^¦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)

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

¦^´_ 1# pupai
­Y±z´¡¤J¾ã­ÓCÄæ«á¥B·|¹ï·s¼WÄæ¦ì©R¦W¨ä¡uÄæ¦ì¦WºÙ¡v¬°«e´£ ¤U¡A«h¹ï©ó±z°£¡u¤ë¦Ò¦¨ÁZ¡v¤£ºâ¶È¥[Á`¦U¡u¤p¦Ò¦¨ÁZ¡vªº°²³]¡A½Ð©óB2Àx¦s®æ¿é¤J¤U¦C¤½¦¡
=SUM(OFFSET(INDIRECT("C"&ROW(2:2)),,,,COUNTA($1:$1)-3))
¦A¦V¤U½Æ»s§Y¥i
½Ð°Ñ¦Ò¡I

TOP

¦^´_  pupai
­Y±z´¡¤J¾ã­ÓCÄæ«á¥B·|¹ï·s¼WÄæ¦ì©R¦W¨ä¡uÄæ¦ì¦WºÙ¡v¬°«e´£ ¤U¡A«h¹ï©ó±z°£¡u¤ë¦Ò¦¨ÁZ¡v¤£ºâ ...
p212 µoªí©ó 2013-10-14 11:06



    P¤j
±zªº¤½¦¡¦æ¤£³q
¦Ó¥B§Ú¥u­nC»PD­ÇÄæ¥[Á`

TOP

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

¦^´_ 3# pupai
½Ð°Ý±z­nªº¬O¤°»ò¡H
¤£µMB2Àx¦s®æª½±µ¥ÎSUM(C2:D2)¤£´N¥i¥H¡H
­Y´¡¤J¾ã­ÓCÄæ¡AB2Àx¦s®æ¤½¦¡SUM(C2:D2)§Y·|Åܧó¬°SUM(D2:E2)¡C
¥i§_¦A¸Ô­z¤@¤U±zªº»Ý¨D¡A¤j¹Ù¨à¤@°_¬ã¨s¡AÁÂÁ¡I

TOP

¦^´_ 3# pupai

³o¼Ë¤l¬O§A»Ý­nªºµ²ªG¶Ü¡H
=SUM(OFFSET(B2,0,1,1,2))

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

¦^´_  pupai

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



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

TOP

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

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

¦^´_  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

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD