how do I add a spreadsheet into a new sum? adding across spreadshe

[Jane]

Ok, so I have this formula
=SUM('2'!C3,'3'!C3,'1'!C3)

but I will need to eventually add more spreadsheets into that sum. Instead
of having to type that in each time, is there another formula/function that i
can use? (Adding across spreadsheets?)

Thanks!
-Jane

 

[Don Guillett]

=sum(1:3!c3)
add sheets BEFORE sheet 4

 

[Bernard Liengme]

=SUM('1:3'!A1)
best wishes

 

[Jane]

Thanks so much!!! I just made it =SUM('1:999'!A1) becuase i don't know how
many spreadsheets i will need! Thanks!!

 

[Dave Peterson]

I like to make a "sandwich" out of my worksheets.

I'd insert two worksheets--one to the far left called "Start" and one to the far
right named "End".

Then I could use a formula like:

=sum('start:end'!N2)
to add up all the worksheets that are between those two "pieces of bread".

The cell with the formula would go in a worksheet that's not inside the
sandwich.

 

[David Biddulph]

Often your best bet is to produce dummy sheets named start and end, and move
start to the beginning and end to the end, and make sure that extra real
data sheets you added are placed between start and end, then you can use
=SUM('start:end'!A1)

 

[Gord Dibben]

Set up a worksheet sandwich.

First you have a Summary sheet.

Then a blank sheet named Start.

Then a couple of your weekly sheets.

Last have a blank sheet named End

In Summary sheet enter this formula =SUM(Start:End!C3)

As you add sheets insert them between Start and End so's they get picked
up by the formula on Summary sheet.


Gord Dibben MS Excel MVP