Forum Discussion
Keep running totals when adding a new worksheet
Hey,
Each week I need to make a copy in Excel of the number of containers we return, which I have been doing in a separate sheet, however I want to keep a running total on the first sheet of how much we have processed so far. Is there a way to keep a running total on the first page and to continue to add to it as I add a new sheet each week or do I need to just go ahead and add 52 pages already?
I have added a screenshot of my first page and what each of the weekly sheets look like, as you can see I have done the first 10 weeks however I will be doing 52 weeks each year.
Each new sheet is the same apart from the numbers apart the that weeks numbers.
Kind regards,
Nick
1 Reply
Yes it is possible. One simple way is by creating 2 blank sheets in between the 1st Week and the last week. (Lets say Start and End sheets)
With the formula =SUM(Start:End!I28) you will calculate the total of the cell I28 for all the sheets between Start and End sheets. It means that any sheet you will may put between those 2 sheets will be part of the calculation.
You can use any function you may want, I just use as example the SUM() function.
.png){kind=link}
.png){kind=link}