how to show the same calculated column total to multiple spreadshe
 

--
Need to know

how to show the same calculated column total to multiple spreadshe
 

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:

how to show the same calculated column total to multiple sprea
 

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:

how to show the same calculated column total to multiple sprea
 

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: