R
roadrunner
--
Need to know
Need to know
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
how to show the same calculated column total to multiple spreadshe
G
Gord Dibben
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
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
R
roadrunner
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?
grand total of these same column totals on a separate spreadsheet. ( as a
recap). Is that possible?
R
Ragdyer
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)
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)