i have opened a new work book, within the book there are 7 sheets (mon,
tue,wed etc) on each sheet i have in my first row 12 individual names and my
first column is times (8.00am every fifteen minutes to 10pm) on the bottom
row i have total of hours used in that particular day - eg mon 8.30am -
2.30pm = 6 hours
i would like to open an eighth sheet that would total all hours for the week
for me!! sounds easy doesnt it!! does it? i am lost ..... if anyone could
help that would be great and save me a lot of time away from the calculator
linda
--
thank u very much

Hi Linda:

Let's say wee have numbers in cell Z100 on 7 sheets and want the sum on
sheet eight.

=SUM(Sheet1:Sheet7!Z100)

will do it
--
Gary''s Student - gsnu200730


"lindyphil14" wrote:

i have opened a new work book, within the book there are 7 sheets (mon,
tue,wed etc) on each sheet i have in my first row 12 individual names and my
first column is times (8.00am every fifteen minutes to 10pm) on the bottom
row i have total of hours used in that particular day - eg mon 8.30am -
2.30pm = 6 hours
i would like to open an eighth sheet that would total all hours for the week
for me!! sounds easy doesnt it!! does it? i am lost ..... if anyone could
help that would be great and save me a lot of time away from the calculator
linda
--
thank u very much

thank u very much fo ur reply ...i will try this tonite!!
sorry 4 the delay is answering but i have just finished work and this is the
first chance i have had to see if there was any responce
--
thank u very much


"Gary''s Student" wrote:

Hi Linda:

Let's say wee have numbers in cell Z100 on 7 sheets and want the sum on
sheet eight.

=SUM(Sheet1:Sheet7!Z100)

will do it
--
Gary''s Student - gsnu200730


"lindyphil14" wrote:

i have opened a new work book, within the book there are 7 sheets (mon,
tue,wed etc) on each sheet i have in my first row 12 individual names and my
first column is times (8.00am every fifteen minutes to 10pm) on the bottom
row i have total of hours used in that particular day - eg mon 8.30am -
2.30pm = 6 hours
i would like to open an eighth sheet that would total all hours for the week
for me!! sounds easy doesnt it!! does it? i am lost ..... if anyone could
help that would be great and save me a lot of time away from the calculator
linda
--
thank u very much

oops just tried it and it didnt work..... the cell was asking me 4 a name
(=sum(name)..
--
thank u very much


"Gary''s Student" wrote:

Hi Linda:

Let's say wee have numbers in cell Z100 on 7 sheets and want the sum on
sheet eight.

=SUM(Sheet1:Sheet7!Z100)

will do it
--
Gary''s Student - gsnu200730


"lindyphil14" wrote:

i have opened a new work book, within the book there are 7 sheets (mon,
tue,wed etc) on each sheet i have in my first row 12 individual names and my
first column is times (8.00am every fifteen minutes to 10pm) on the bottom
row i have total of hours used in that particular day - eg mon 8.30am -
2.30pm = 6 hours
i would like to open an eighth sheet that would total all hours for the week
for me!! sounds easy doesnt it!! does it? i am lost ..... if anyone could
help that would be great and save me a lot of time away from the calculator
linda
--
thank u very much

For our formula to work, the sheets must be named:

Sheet1
Sheet2
Sheet3
Sheet4
Sheet5
Sheet6
Sheet7

A Name error means Excel can't find one or more of the 7
--
Gary''s Student - gsnu200730


"lindyphil14" wrote:

oops just tried it and it didnt work..... the cell was asking me 4 a name
(=sum(name)..
--
thank u very much


"Gary''s Student" wrote:

Hi Linda:

Let's say wee have numbers in cell Z100 on 7 sheets and want the sum on
sheet eight.

=SUM(Sheet1:Sheet7!Z100)

will do it
--
Gary''s Student - gsnu200730


"lindyphil14" wrote:

i have opened a new work book, within the book there are 7 sheets (mon,
tue,wed etc) on each sheet i have in my first row 12 individual names and my
first column is times (8.00am every fifteen minutes to 10pm) on the bottom
row i have total of hours used in that particular day - eg mon 8.30am -
2.30pm = 6 hours
i would like to open an eighth sheet that would total all hours for the week
for me!! sounds easy doesnt it!! does it? i am lost ..... if anyone could
help that would be great and save me a lot of time away from the calculator
linda
--
thank u very much

thank u very much i will rename the sheets and try again
--
thank u very much


"Gary''s Student" wrote:

For our formula to work, the sheets must be named:

Sheet1
Sheet2
Sheet3
Sheet4
Sheet5
Sheet6
Sheet7

A Name error means Excel can't find one or more of the 7
--
Gary''s Student - gsnu200730


"lindyphil14" wrote:

oops just tried it and it didnt work..... the cell was asking me 4 a name
(=sum(name)..
--
thank u very much


"Gary''s Student" wrote:

Hi Linda:

Let's say wee have numbers in cell Z100 on 7 sheets and want the sum on
sheet eight.

=SUM(Sheet1:Sheet7!Z100)

will do it
--
Gary''s Student - gsnu200730


"lindyphil14" wrote:

i have opened a new work book, within the book there are 7 sheets (mon,
tue,wed etc) on each sheet i have in my first row 12 individual names and my
first column is times (8.00am every fifteen minutes to 10pm) on the bottom
row i have total of hours used in that particular day - eg mon 8.30am -
2.30pm = 6 hours
i would like to open an eighth sheet that would total all hours for the week
for me!! sounds easy doesnt it!! does it? i am lost ..... if anyone could
help that would be great and save me a lot of time away from the calculator
linda
--
thank u very much

Don't rename the sheets.

Insert a new blank sheet before the sheets to SUM

Name it Start

Insert a new blank sheet after the sheets to SUM

Formula would be =SUM(Start:End!Z100)

When adding new sheets in the future make sure they are inserted between Start
and End.


Gord Dibben MS Excel MVP



On Sun, 17 Jun 2007 14:24:00 -0700, lindyphil14
wrote:

thank u very much i will rename the sheets and try again

thank u gord
i know it sounds silly but..... i have inserted a sheet at the begining and
named it start but it is not allowing me to insert another at the end, i have
monday thro to sunday but when i try to insert after sunday it go in between
saturday & sunday!!
--
thank u very much


"Gord Dibben" wrote:

Don't rename the sheets.

Insert a new blank sheet before the sheets to SUM

Name it Start

Insert a new blank sheet after the sheets to SUM

Formula would be =SUM(Start:End!Z100)

When adding new sheets in the future make sure they are inserted between Start
and End.


Gord Dibben MS Excel MVP



On Sun, 17 Jun 2007 14:24:00 -0700, lindyphil14
wrote:

thank u very much i will rename the sheets and try again

wheyyyy i have placed a start and end sheet!!! now to get the formula right
--
thank u very much


"Gord Dibben" wrote:

Don't rename the sheets.

Insert a new blank sheet before the sheets to SUM

Name it Start

Insert a new blank sheet after the sheets to SUM

Formula would be =SUM(Start:End!Z100)

When adding new sheets in the future make sure they are inserted between Start
and End.


Gord Dibben MS Excel MVP



On Sun, 17 Jun 2007 14:24:00 -0700, lindyphil14
wrote:

thank u very much i will rename the sheets and try again

mmmm now it tells me excel cannot calculate a formula, i am creating a
circular reference!

--
thank u very much


"Gord Dibben" wrote:

Don't rename the sheets.

Insert a new blank sheet before the sheets to SUM

Name it Start

Insert a new blank sheet after the sheets to SUM

Formula would be =SUM(Start:End!Z100)

When adding new sheets in the future make sure they are inserted between Start
and End.


Gord Dibben MS Excel MVP



On Sun, 17 Jun 2007 14:24:00 -0700, lindyphil14
wrote:

thank u very much i will rename the sheets and try again

Move the sheet with the formula, from between "Start & End".

George Gee


"lindyphil14" wrote in message
...
mmmm now it tells me excel cannot calculate a formula, i am creating a
circular reference!

--
thank u very much


"Gord Dibben" wrote:

Don't rename the sheets.

Insert a new blank sheet before the sheets to SUM

Name it Start

Insert a new blank sheet after the sheets to SUM

Formula would be =SUM(Start:End!Z100)

When adding new sheets in the future make sure they are inserted between
Start
and End.


Gord Dibben MS Excel MVP



On Sun, 17 Jun 2007 14:24:00 -0700, lindyphil14
wrote:

thank u very much i will rename the sheets and try again

OMG
i did it!!!!
thank u gord and garys student for ur invaluable help
--
thank u very much


"Gord Dibben" wrote:

Don't rename the sheets.

Insert a new blank sheet before the sheets to SUM

Name it Start

Insert a new blank sheet after the sheets to SUM

Formula would be =SUM(Start:End!Z100)

When adding new sheets in the future make sure they are inserted between Start
and End.


Gord Dibben MS Excel MVP



On Sun, 17 Jun 2007 14:24:00 -0700, lindyphil14
wrote:

thank u very much i will rename the sheets and try again

Don't include the summary sheet among the start - finish sheets
best would be to drag it to the left (just drag it with the mouse) and have
the summary as the first sheet then do the calculation with the rest of the
sheets


--
Regards,

Peo Sjoblom



"lindyphil14" wrote in message
...
mmmm now it tells me excel cannot calculate a formula, i am creating a
circular reference!

--
thank u very much


"Gord Dibben" wrote:

Don't rename the sheets.

Insert a new blank sheet before the sheets to SUM

Name it Start

Insert a new blank sheet after the sheets to SUM

Formula would be =SUM(Start:End!Z100)

When adding new sheets in the future make sure they are inserted between
Start
and End.


Gord Dibben MS Excel MVP



On Sun, 17 Jun 2007 14:24:00 -0700, lindyphil14
wrote:

thank u very much i will rename the sheets and try again

Apologies for not including Peo's advice with my original post but you're sorted
out now.

Good thing there are many of us hanging around to pick up what others forget.


Gord

On Mon, 18 Jun 2007 14:06:00 -0700, lindyphil14
wrote:

OMG
i did it!!!!
thank u gord and garys student for ur invaluable help

thank uso much peo and george
--
thank u very much


"Peo Sjoblom" wrote:

Don't include the summary sheet among the start - finish sheets
best would be to drag it to the left (just drag it with the mouse) and have
the summary as the first sheet then do the calculation with the rest of the
sheets


--
Regards,

Peo Sjoblom



"lindyphil14" wrote in message
...
mmmm now it tells me excel cannot calculate a formula, i am creating a
circular reference!

--
thank u very much


"Gord Dibben" wrote:

Don't rename the sheets.

Insert a new blank sheet before the sheets to SUM

Name it Start

Insert a new blank sheet after the sheets to SUM

Formula would be =SUM(Start:End!Z100)

When adding new sheets in the future make sure they are inserted between
Start
and End.


Gord Dibben MS Excel MVP



On Sun, 17 Jun 2007 14:24:00 -0700, lindyphil14
wrote:

thank u very much i will rename the sheets and try again