Hi i have a sheet set up for each week for my work and i am trying to do
auto sums to add each weeks figures from Cell n35 at the end i will have 52
sheets so i would like to know how to add figures from each week
automatically.

Many thanks

Michael

hi
try this...
=SUM(Sheet1:Sheet52!N35)

regards
FSt1

"Michael Higgins" wrote:

Hi i have a sheet set up for each week for my work and i am trying to do
auto sums to add each weeks figures from Cell n35 at the end i will have 52
sheets so i would like to know how to add figures from each week
automatically.

Many thanks

Michael

Michael

Set up a worksheet sandwich.

First you have a Summary sheet.

Then a blank sheet named Start.

Then a couple of your weekly sheets.

Last have a blank sheet named End

In Summary sheet enter this formula =SUM(Start:End!N35)

As you add weekly sheets insert them between Start and End so's they get picked
up by the formula on Summary sheet.

If you want a balance carry-over from sheet to sheet you will need something
else.

Post back if that is the case.


Gord Dibben MS Excel MVP


On Sun, 27 Jan 2008 19:41:24 GMT, "Michael Higgins"
wrote:

Hi i have a sheet set up for each week for my work and i am trying to do
auto sums to add each weeks figures from Cell n35 at the end i will have 52
sheets so i would like to know how to add figures from each week
automatically.

Many thanks

Michael

Another nice tip is on this page from Lori
http://www.rondebruin.nl/linksum.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
Michael

Set up a worksheet sandwich.

First you have a Summary sheet.

Then a blank sheet named Start.

Then a couple of your weekly sheets.

Last have a blank sheet named End

In Summary sheet enter this formula =SUM(Start:End!N35)

As you add weekly sheets insert them between Start and End so's they get picked
up by the formula on Summary sheet.

If you want a balance carry-over from sheet to sheet you will need something
else.

Post back if that is the case.


Gord Dibben MS Excel MVP


On Sun, 27 Jan 2008 19:41:24 GMT, "Michael Higgins"
wrote:

Hi i have a sheet set up for each week for my work and i am trying to do
auto sums to add each weeks figures from Cell n35 at the end i will have 52
sheets so i would like to know how to add figures from each week
automatically.

Many thanks

Michael

Never saw that one before. Very nice.

=SUM('*'!A20)


Gord


On Sun, 27 Jan 2008 22:01:44 +0100, "Ron de Bruin"
wrote:

Another nice tip is on this page from Lori
http://www.rondebruin.nl/linksum.htm

Learn something new every day!

Neat trick.<bg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Never saw that one before. Very nice.

=SUM('*'!A20)


Gord


On Sun, 27 Jan 2008 22:01:44 +0100, "Ron de Bruin"

wrote:

Another nice tip is on this page from Lori
http://www.rondebruin.nl/linksum.htm