Time Totals in a Workbook
 

Hi,
I have a workbook where each sheet represents one week. I have employees
listed in rows and the column headings are "Hours Worked", Overtime, Sick
Time, etc.
I have a Totals page that I need to tally each week (total hours) for any or
all columns. I also have blank pages "Start" and "End". On the Totals page
for the calculation - =Sum(Start:End!B4). All pages are formatted under the
[h]:mm:ss. I am also receiving a circular reference error each time the
workbook is opened.
I need to be able to insert a new sheet each week.
Can anyone tell me why this doesn't work?

Thanks in advance.
Judy

Time Totals in a Workbook
 

Judy

can only hazard a guess that the Totals page is actually between the blank
Start and End sheets.

I set up a test from scratch and it worked fine. Saved it, closed it,
opened it OK. Moved the Totals sheet after the Start sheet and immediately
got the circular reference.

Would recommend sheet order: Totals | Start | Sheet1 | Sheet2 | ... | Sheetn
| End

You should be able to insert sheets and have them included in the SUM

Regards

Trevor


"judyblue" wrote in message
...
Hi,
I have a workbook where each sheet represents one week. I have employees
listed in rows and the column headings are "Hours Worked", Overtime, Sick
Time, etc.
I have a Totals page that I need to tally each week (total hours) for any
or
all columns. I also have blank pages "Start" and "End". On the Totals
page
for the calculation - =Sum(Start:End!B4). All pages are formatted under
the
[h]:mm:ss. I am also receiving a circular reference error each time the
workbook is opened.
I need to be able to insert a new sheet each week.
Can anyone tell me why this doesn't work?

Thanks in advance.
Judy