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.

Jane wrote:

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

--

Dave Peterson