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