 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2007hi i am new to excel heelllpppp
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  Signaturethank 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 SignatureGary''s Student - gsnu200730 > 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 [quoted text clipped - 5 lines] > help that would be great and save me a lot of time away from the calculator > linda 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 Signaturethank u very much > Hi Linda: > [quoted text clipped - 14 lines] > > help that would be great and save me a lot of time away from the calculator > > linda oops just tried it and it didnt work..... the cell was asking me 4 a name (=sum(name).. Signaturethank u very much > Hi Linda: > [quoted text clipped - 14 lines] > > help that would be great and save me a lot of time away from the calculator > > linda 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 SignatureGary''s Student - gsnu200730 > oops just tried it and it didnt work..... the cell was asking me 4 a name > (=sum(name).. [quoted text clipped - 17 lines] > > > help that would be great and save me a lot of time away from the calculator > > > linda thank u very much i will rename the sheets and try again Signaturethank u very much > For our formula to work, the sheets must be named: > [quoted text clipped - 29 lines] > > > > help that would be great and save me a lot of time away from the calculator > > > > linda 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 >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!! Signaturethank u very much > Don't rename the sheets. > [quoted text clipped - 12 lines] > > >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 Signaturethank u very much > Don't rename the sheets. > [quoted text clipped - 12 lines] > > >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! Signaturethank u very much > Don't rename the sheets. > [quoted text clipped - 12 lines] > > >thank u very much i will rename the sheets and try again Move the sheet with the formula, from between "Start & End". George Gee > mmmm now it tells me excel cannot calculate a formula, i am creating a > circular reference! [quoted text clipped - 16 lines] >> >> >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 SignatureRegards, Peo Sjoblom > mmmm now it tells me excel cannot calculate a formula, i am creating a > circular reference! [quoted text clipped - 16 lines] >> >> >thank u very much i will rename the sheets and try again thank uso much peo and george Signaturethank u very much > 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 [quoted text clipped - 21 lines] > >> > >> >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 Signaturethank u very much > Don't rename the sheets. > [quoted text clipped - 12 lines] > > >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 >OMG >i did it!!!! >thank u gord and garys student for ur invaluable help |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.