Multi-sheet totals
 

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

"Jim M" wrote in message
am...
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

In article , Nick
wrote:

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

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!
==============================================


"Jim M" wrote in message
am...
In article , Nick
wrote:

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

Brilliant, that works great thanks.

More inane questions coming soon...!

Jim

In article , RagDyeR
wrote:

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

http://tinyurl.com/6gujb

Another good tip! Thanks for that.

Hmm, this NG is goood...

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
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Jim M" wrote in message
am...
In article , RagDyeR
wrote:

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

http://tinyurl.com/6gujb

Another good tip! Thanks for that.

Hmm, this NG is goood...

Jim

In article , Ragdyer
wrote:

Thanks for the feed-back ... but ... don't you really think that GREAT is
perhaps a more accurate assessment of these XL groups?<vbg

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

Jim