Multi-sheet totals

  • Thread starter Thread starter Jim M
  • Start date Start date
J

Jim M

Hi folks,

I'm fairly new to the "joys" of Excel and would appreciate some advice.

I have a multi-sheet workbook. Each sheet has a cell (the same cell on
every sheet), let's call it "D2", with a "total" for that sheet.

Is there a *simple* way of adding up all the "D2's" in the workbook and
putting that sum on the last page? Ideally I want it to keep adding up
all the "D2" cells, even when I add new sheets.

At the moment I'm using the old =SUM('sheet1'!D2+'sheet2'!D2) trick,
but I'm getting a bit sick of manually adding sheet names to that
formula!

I'm on Excel Mac, by the way. Dunno if that matters...

TIA!
Jim
 
Simple

In the last sheet type
=Sum(
Then select the first sheet and cell i.e. Sheet1!D2
Whilst holding the shift key click the final sheet and press enter.

You will get the forumla =SUM(Sheet1:Sheet10!D2).

That will sum all sheets 1 to 10 for the cell D2

Nick
 
Nick said:
Simple

In the last sheet type
=Sum(
Then select the first sheet and cell i.e. Sheet1!D2
Whilst holding the shift key click the final sheet and press enter.

You will get the forumla =SUM(Sheet1:Sheet10!D2).

That will sum all sheets 1 to 10 for the cell D2
Click to expand...

Brilliant, that works great thanks.

More inane questions coming soon...!

Jim
 
Since you say that you are constantly adding new sheets, take notice of the
end of this old post:

http://tinyurl.com/6gujb

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Nick said:
Simple

In the last sheet type
=Sum(
Then select the first sheet and cell i.e. Sheet1!D2
Whilst holding the shift key click the final sheet and press enter.

You will get the forumla =SUM(Sheet1:Sheet10!D2).

That will sum all sheets 1 to 10 for the cell D2
Click to expand...

Brilliant, that works great thanks.

More inane questions coming soon...!

Jim
 
Thanks for the feed-back ... but ... don't you really think that GREAT is
perhaps a more accurate assessment of these XL groups?<vbg>
 
Ragdyer said:
Thanks for the feed-back ... but ... don't you really think that GREAT is
perhaps a more accurate assessment of these XL groups?<vbg>
Click to expand...

I will withold that until someone answers my other question! <ebg>

Jim
 
Back
Top