Forum Discussion
Excel Sum Formula referencing a previous sheet
I am trying to create a formula that adds a cell from the sheet to the left of the current sheet. I have to keep a running total on weekly hours and create a sheet for every week. I don't want to hav...
shurleyWe can't really refer to the previous sheet within a formula accurately, but we could get clever with this.
For example, if in cell A1 you had the name of the previous sheet you could reference it within the SUM function using INDIRECT like this;
=SUM(INDIRECT("'"&A1&"'!B2:B8"))
This sums range B2:B8 from the sheet name written in cell A1. Now this is just an example. If you are using a consistent way of naming these sheets there may be a way of getting clever with this. But event typing a sheet name into a cell (or using a formula for this) is easier than editing the formula each time.