Question Locked

Excel 2003 Carry over running total across worksheets

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I created a timesheet for employees hours and wages. The bottom of the sheet has the week's total wages. I create a new worksheet for each subsequent week by copying the previous worksheet. How can i get the new worksheet to show a runniong total of all the wages from the previous weeks automatically.

2 replies

by jdclyde

Just to be clear, you are using multiple tabs in the same file, not separate files, right?

A field in each tab that has the running total would need a formula like this:

=sheet1:sheet26!b1

That would do a sum of the range of that single cell, on each tab, and give you the total to that point. for this example, the formula is in cell a1.

This discussion is closed to new replies.