If you are consolidating multiple structurally identical worksheets (tabs) in Excel, say to roll-up various product line financials for a business unit, you may have manually linked each tab via a formula that follows:
Instead you could define the range of sheets to sum, such as:
The attached workbook and video walk through this process.
Download the Excel Workbook here.
If you had tabs labelled Jan through Dec, you could simply just use this formula:
In my example above, blank dummy tabs were added that were names “<” and “>” – these dummy tabs can be named anything, but I find “<“, and “<<“, and “<<<” for different sequences of summed looks good in the formulas.
©2018 Ben Etzkorn