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

[µo°Ý] SUMÁ`¦X¥[Á`

[µo°Ý] SUMÁ`¦X¥[Á`

=SUM('[1¤ë.xls]1'!H5,'[1¤ë.xls]2'!H5,'[3¤ë.xls]3'!H5,'[1¤ë.xls]4'!H5,'[1¤ë.xls]5'!H5,'[1¤ë.xls]6'!H5,'[1¤ë.xls]7'!H5)

³o¬O­ì©lµ{¦¡½X¥i¥H°õ¦æ¥[Á`¡A¥[Á`ªº¦ì¸m³£¬O¦P¤@­ÓH5¡A¥u¬O¤é´Á¤u§@ªí¦W¤l¤£¦P¡A

¦]¬°­n±`§ï¤é´Á©Ò¥H·Q­n±N¤u§@ªí1~7³]¬°¥iÅܧ󪺠  ¨Ò¦p1~7¤U¦¸§ï¬°8~14¡A15~21  ¤]¦³¥i¯à¸ó¤ë ©Ò¥H1¤ë¤]¦³¥i¯à§ï¬°2¤ë

¦³¨Ï¥ÎCONCATENATE(1¤ë.xls],1,'!H5)¡A¦ý¬OSUM´N·|Åã¥Ü¿ù»~  ¡A½Ð°Ý¦U¦ì«e½ú¸Ó¦p¦ó¨M¸Ñ?

·P¿E!!!!!!!!!!!!!

=SUM(Sheet1:Sheet7!H5)
·|¦X­pSHEET1:SHEET7¤§¶¡ªºH5
­ì«h­n¦P¤@­ÓÀx¦s®æ.

TOP

¦^´_ 2# ANGELA


    ·PÁ ¡A­ì¨ÓÁÙ¥i¥H³o¼Ë¥Î¤X

TOP

¥i¥H¥Î¦ý·|¦³¸ó¤G­ÓÀɪº¡A¦³¤°»òªk¤è¥i¥H¿ï©w¤é´Á µM«á²Î­p¶Ü?
1¤ë27·|¸ó¨ì2¤ë2¤é ¡A¦]¬°ÀɬO¤@­Ó¤ë¤@­Ó¤ë¦sªº
³Ì¦n¥u§ï¤ë¸ò¤é´Á ´N¥i¥H²Î­p¤F

TOP

=SUM('C:\Documents and Settings\user\®à­±\[Book1.xls]Sheet1:Sheet3'!A1)+SUM(Sheet2:Sheet4!A1)
«D·í«e¤u§@ªí,¦C¥X¸ô®|§Y¥i,

TOP

¦^´_ 5# ANGELA


    ·PÁª©¥D¸Ñµª §Úª¾¹D¥i¥H³o¼Ë¥Î

¦ý§Ú¬O·N«ä¬O¦]¬°¤é´Á±`ÅÜ°Ê  ¨Ò¦pSUM(A1:A5) ........................A1©MA5¬O¥i¥HÅܰʪº

¦b­^¤åA¤£ÅÜ   Àx¦s®æ  B1=1  B2=5   ¥i¥HÀH®É§ó§ïB1=1  B2=9   «h¤½¦¡ÅÜ=SUM(A1:A9)

TOP

¦^´_ 6# axen0520

=SUM(INDIRECT("A"&B1&":A"&B2))

¬O³o¼Ë¶Ü?

TOP

¦^´_ 7# man65boy


    ¤Ó·PÁ¤F¡A´N¬O­n³o¼Ë¡C
¤j®a¦n

TOP

¦A½Ð±Ð¦U¦ì«e½ú
=SUM('1:31'!H5)  µ{¦¡ ¥i¥H¥[Á`

¦ý¬O§ï¦¨=SUM(INDIRECT("'"&B5&":"&C5&"'!H5"))

«o¤£¦æ#ERF!   B5=1     C5=31
¤j®a¦n

TOP

¦^´_ 9# axen0520


    INDIRECT¤£¤ä´©³oºØ¥Îªk.

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤H¤£©È¿ù¡A´N©È¤£§ï¹L¡A§ï¹L¨Ã¤£Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD