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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jane" wrote in message
...
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

=SUM('1:3'!A1)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Jane" wrote in message
...
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

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

"Bernard Liengme" wrote:

=SUM('1:3'!A1)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Jane" wrote in message
...
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

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

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)
--
David Biddulph

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

"Bernard Liengme" wrote:

=SUM('1:3'!A1)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Jane" wrote in message
...
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

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

On Wed, 30 Jan 2008 08:52:00 -0800, 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