Sum function across multiple sheets
 

Hi,
What is the spelling of the SUM function in order to sum up specific
cell (or range) across all the sheets within the same workbook -
without specifing each sheet name seperately and includes all sheets of
the workbook (even if new sheest are added later).

Thanks in advance. Neta


--
neta
------------------------------------------------------------------------
neta's Profile: http://www.excelforum.com/member.php...fo&userid=7624
View this thread: http://www.excelforum.com/showthread...hreadid=395665

Hi,

=SUM('Sheet1:Sheet3'!A1:A20)

Notes:
The formula assumes that Sheet1 is the first and Sheet3 is the last sheets
in a range of sheets.
I added the single quatation marks jut in case any of the two names contain
spaces.

Regards,
KL


"neta" wrote in message
...

Hi,
What is the spelling of the SUM function in order to sum up specific
cell (or range) across all the sheets within the same workbook -
without specifing each sheet name seperately and includes all sheets of
the workbook (even if new sheest are added later).

Thanks in advance. Neta


--
neta
------------------------------------------------------------------------
neta's Profile:
http://www.excelforum.com/member.php...fo&userid=7624
View this thread: http://www.excelforum.com/showthread...hreadid=395665

Something like:

=SUM('Sheet1:Sheet10'!A1)

You don't need the single quotes in this example but you would need them if
the sheet names contained spaces.

There is no way to automatically adjust the formula for sheets added at the
beginning or the end of the existing worksheets, unless the two end sheets
are "dummy" sheets that will always stay hidden. Sheets that are inserted
between the end sheets will be automatically accounted for.

--

Vasant




"neta" wrote in message
...

Hi,
What is the spelling of the SUM function in order to sum up specific
cell (or range) across all the sheets within the same workbook -
without specifing each sheet name seperately and includes all sheets of
the workbook (even if new sheest are added later).

Thanks in advance. Neta


--
neta
------------------------------------------------------------------------
neta's Profile:
http://www.excelforum.com/member.php...fo&userid=7624
View this thread: http://www.excelforum.com/showthread...hreadid=395665

See if this old post helps:

http://tinyurl.com/dhoaz


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"neta" wrote in message
...

Hi,
What is the spelling of the SUM function in order to sum up specific
cell (or range) across all the sheets within the same workbook -
without specifing each sheet name seperately and includes all sheets of
the workbook (even if new sheest are added later).

Thanks in advance. Neta


--
neta
------------------------------------------------------------------------
neta's Profile:
http://www.excelforum.com/member.php...fo&userid=7624
View this thread: http://www.excelforum.com/showthread...hreadid=395665