Consolidating data in excel 2016 dating rules tv series
The easiest way to solve this problem would be to move away from your current model of splitting the data into separate sheets and instead keep all of the data on a single sheet.
(By default, the used range is selected for each worksheet) See screenshot: 3.
Create a new workbook that you want to put the consolidated data, then click Data Consolidate, see screenshot: 2.
In the Consolidate dialog box, select Sum (as we want to show sum of values for consolidation ) from Function option, then click button from Reference to select the range that you want to summarize, and then click Add button to add the range reference to the All references list box. Using the same way to add other ranges to the All references list box.
Here, I will introduce you some quick tricks to solve it.
Summarize data from multiple worksheets/workbooks into one worksheet with Consolidate function Summarize data from multiple worksheets/workbooks into one worksheet with Kutools for Excel This Consolidate feature combines values and do some calculations from multiple worksheets or workbooks into one worksheet.