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 ...
.png){kind=link}
.png){kind=link}
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.