In this guest article, Joseph Reese shows us some Excel formulas to help us summarize data across worksheets. Find out more about Joseph at the end of this post.
In this article you will discover a neat way to summarize data across Excel sheets without having to reference each of them. This technique will work even if you add a new sheet.
Defining a Range of Sheets
Consider the following example: The fictitious expense reports for the equally fictitious XYZ Widget Company’s various offices. Each sheet in the workbook contains the expense data for each of the company’s offices. Below you can see the expense data for the New-York office:
The Expenses workbook holds a similar sheet for the Chicago and LA offices.