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

[µo°Ý] OFFSET³o¤½¦¡¤@°Ý

[µo°Ý] OFFSET³o¤½¦¡¤@°Ý

=SUM(OFFSET(C3:E5,-1,0,3,3))

Height    ¬O³]©w¶Ç¦^ªº°Ñ·Ó¦ì§}À³¥]¬AªºÀx¦s®æ°ª«× (Àx¦s®æ½d³òªº¦C¼Æ) ªº¼Æ­È¡C¦¹¤Þ¼Æ¥²¶·¬O¥¿¼Æ¡C

Width    ¬O³]©w¶Ç¦^ªº°Ñ·Ó¦ì§}À³¥]¬AªºÀx¦s®æ¼e«× (Àx¦s®æ½d³òªºÄæ¼Æ) ªº¼Æ­È¡C¦¹¤Þ¼Æ¥²¶·¬O¥¿¼Æ¡C

§Ú¤£¤jÀ´¤W­±ªºHEIGHT¤ÎWIDTHªº¸ÑÄÀ»¡©ú..¤£ª¾¦³­þ¦ì¤j¤j¥i¥H¸Ñ»¡¤@µf..THANK YOU
rrriiiccckkkyyy

TOP

«z
²M·¡¤S©ú¥Õ
²¼ä¦³¤OªºÅý§Ú©ú¥Õ³o­Ó¤½¦¡ªº¥Î³~
ÁÂÁÂÅo
jeason

TOP

ANGELA ªºÁ|¨Ò¤w»¡©úªº«Ü²M·¡~

TOP

«D±`²M³B.THANK YOU¤j¤j..
¦pªGEXCELªº»¡©ú¯à¦³³oºN²M³B´N¦n¤F...Æg
rrriiiccckkkyyy

TOP

­ì¨ÓÁÙ¥i¥H³o¼Ë¥Î~ÁÂÁÂ¥ý¶i«ü¾É

TOP

ÁÂÁÂAngela ¼g±o¦n¥J²Ó ·P®¦

TOP

¦ý¬O¦n¹³¤£ª¾¹D¤°»ò®É­Ô·|¥Î¨ì³o­Ó¨ç¼Æ...

TOP

¤ñEXCEL»¡©ú§ó¥[¸Ô²Ó©öÀ´¡A·PÁ¡I

TOP

¦^´_ 1# ricky08240920

>> =SUM(OFFSET(C3:E5,-1,0,3,3))
>> Height    ¬O³]©w¶Ç¦^ªº°Ñ·Ó¦ì§}À³¥]¬AªºÀx¦s®æ°ª«× (Àx¦s®æ½d³òªº¦C¼Æ) ªº¼Æ­È¡C¦¹¤Þ¼Æ¥²¶·¬O¥¿¼Æ¡C
>> Width    ¬O³]©w¶Ç¦^ªº°Ñ·Ó¦ì§}À³¥]¬AªºÀx¦s®æ¼e«× (Àx¦s®æ½d³òªºÄæ¼Æ) ªº¼Æ­È¡C¦¹¤Þ¼Æ¥²¶·¬O¥¿¼Æ¡C
>> §Ú¤£¤jÀ´¤W­±ªºHEIGHT¤ÎWIDTHªº¸ÑÄÀ»¡©ú..¤£ª¾¦³­þ¦ì¤j¤j¥i¥H¸Ñ»¡¤@µf..THANK YOU

OFFSET(reference,rows,cols,height,width)

Height ¥i¥H¥¿­t¡A¥¿´N©¹¤Uºâ¡A­t´N©¹¤Wºâ
width   ¥i¥H¥¿­t¡A¥¿´N©¹¥kºâ¡A­t´N©¹¥ªºâ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD