Sum function across multiple sheets

N

neta

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

Thanks in advance. Net
 
K

KL

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
 
V

Vasant Nanavati

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.
 
Top