hi i am new to excel heelllpppp

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Gord Dibben]

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

 

[Guest]

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

 

[Guest]

wheyyyy i have placed a start and end sheet!!! now to get the formula right

 

[Guest]

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

 

[George Gee]

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

George Gee

 

[Guest]

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

 

[Peo Sjoblom]

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

 

[Gord Dibben]

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

 

[Guest]

thank uso much peo and george