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

¦p¦ó§Q¥Î½d³ò¦WºÙ±o¥X¬ÛÃö¦æ¼Æ

¦p¦ó§Q¥Î½d³ò¦WºÙ±o¥X¬ÛÃö¦æ¼Æ

¥»©«³Ì«á¥Ñ enoch ©ó 2017-5-25 11:03 ½s¿è

¦p¦WºÙAA ªº½d³ò¬OA2 : A5
¦p¦ó§Q¥Î¦WºÙ AA  ªº¦æ¼Æ 2-5 ¥h®M¥Î¨ì¨ä¥¦¤½¦¡¤W
¨Ò¦p·Q­pºâ
B1 =Sum(B2 : B5)
C1= Sum(C2 : C5)

·íAA ½d³ò§ï¬° A4 : A10 ®É
B1 =Sum(B4 : B10)
C1= Sum(C4 : C10)

½Ð«ü±Ð

http://blog.xuite.net/hcm19522/twblog/508547597
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 1# enoch

A¥[Á`
=SUM(OFFSET(AA,,0))

B¥[Á`
=SUM(OFFSET(AA,,1))

C¥[Á`
=SUM(OFFSET(AA,,2))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

­ì¨Ó¥i¥HËݲ³æ, ÁÂÁÂ

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD