--
Need to know

Not too sure of what you need.

Post some more detail in the body of your message, not in the subject line.

Could be you need a 3-d formula but hard to say.


Gord Dibben MS Excel MVP

On Sun, 15 Oct 2006 09:28:02 -0700, roadrunner
wrote:

I have column totals on 15 different spreadsheets and I want to create a
grand total of these same column totals on a separate spreadsheet. ( as a
recap). Is that possible?
--
Need to know


"Gord Dibben" wrote:

Not too sure of what you need.

Post some more detail in the body of your message, not in the subject line.

Could be you need a 3-d formula but hard to say.


Gord Dibben MS Excel MVP

On Sun, 15 Oct 2006 09:28:02 -0700, roadrunner
wrote:

Are all the sheets configured the same ... meaning ... are the total cells
the same on all sheets (i.e. A25)?

If so, try this:

=SUM(Sheet1:Sheet15!A25)

The sheets to be included in this formula *must* be physically sandwiched
between Sheet1 and Sheet15 in the scroll bar.

You can move sheets in and out of the sandwich, changing the total.
This works well when evaluating "what if" scenarios.

Some people insert 2 blank "dummy" sheets, named "Start" and "End", and
place the actual data sheets between them.
This makes the formula:

=SUM(Start:End!A25)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"roadrunner" wrote in message
...
I have column totals on 15 different spreadsheets and I want to create a
grand total of these same column totals on a separate spreadsheet. ( as a
recap). Is that possible?
--
Need to know


"Gord Dibben" wrote:

Not too sure of what you need.

Post some more detail in the body of your message, not in the subject
line.

Could be you need a 3-d formula but hard to say.


Gord Dibben MS Excel MVP

On Sun, 15 Oct 2006 09:28:02 -0700, roadrunner
wrote: