Excel multi-spreadsheet question

real1314

Stompa wrote: »

Or you could just use =SUM(Sheet1:Sheet99!A1)

or even =SUM('*'!A1) for all sheets.

Use this method as it's the most flexible (especially compared to '=Sum(sheet1A1+sheet2A2...) ; but make one tweak - set up a sheet named "Start" and another named "End" - set up the formula to add up from Start to End and that way you can just add extra sheets between these when required, or can delete sheets which are no longer needed, without the formula breaking.

paddyrg

Guys above, don't reinvent the wheel! If you don't know the Consolidate functionality it does just this, plus it can also adapt to missing rows if needed.

Mr_Toad

paddyrg wrote: »

Guys above, don't reinvent the wheel! If you don't know the Consolidate functionality it does just this, plus it can also adapt to missing rows if needed.

Agreed.

If there's one thing I learned from the huge Excel reference book I bought it's that there are at least a dozen ways to do exactly the same thing.

EchoLocation

If it's not a large amount of cells just use this...

Stompa wrote: »

Or you could just use =SUM(Sheet1:Sheet99!A1)

or even =SUM('*'!A1) for all sheets.

If it is a larger amount of cells (or you'd like to explore Excel's useful functions) use this...

paddyrg wrote: »

Sounds like you want 'consolidate'

http://www.excel-easy.com/examples/consolidate.html