Forum Discussion
Solved
Average of a cell across multiple sheets that allows adding sheets
Hello, I am trying to have a running average of a particular cell across a range of sheets that grows. I'm using this formula =SUM('1:1 (9)'!I17)/(SHEETS()-2) I'm copying the last sheet in e...
I'd add an empty sheet after the last sheet with data. Name it Dummy. You can then use
SUM('1:Dummy'!I17)
When you have to copy the last sheet with data, insert the copy before the Dummy sheet.
That way, the sum will always be correct. without you having to adjust the formula.
I'd add an empty sheet after the last sheet with data. Name it Dummy. You can then use
SUM('1:Dummy'!I17)
When you have to copy the last sheet with data, insert the copy before the Dummy sheet.
That way, the sum will always be correct. without you having to adjust the formula.
HansVogelaar wow, thank you that is so simple now that I know the answer. Dave
