ªð¦^¦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
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

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 : ¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD