Forum Discussion
Calculating an average across multiple tabs and all future tabs
I'm hoping this is a simple question: I would like to calculate an average of the same cell, in multiple tabs, and all future tabs that I add. So, for example: If each tab had a value that was t...
Insert an empty sheet before the first sheet and name it Start.
Insert an empty sheet after the last sheet and name it End.
You can then use a formula such as
=AVERAGE(Start:End!B13)
Insert any new sheet between Start and End. The relevant cell in the new sheet will automatically be included in the average.
Since AVERAGE ignores blank cells, the cells in the Start and End sheets won't affect the result.
HansVogelaar - this is perfect - thanks so much!