Examples of consolidating data in excel
When you move to a different source worksheet, Excel will, by default, "suggest" the same range that you highlighted in the previous worksheet.
Therefore, if the data in each source range occupies the same cells, you don't have to highlight each range—you can simply click Add after activating the appropriate worksheet.
When you do, Excel will add that range's address to the All References text box.
Once you've specified the first source range, you should specify the others in the same way—by highlighting them and clicking Add.
In the Function list box, choose the summary function you want to use. You specify individual source ranges in the Reference text box and then click the Add button to place the reference in the All References list box.
(By default, this box will contain the addresses of the ranges you specified the last time you used the Consolidate... To remove those addresses, select them and then click the Delete button.) The form of the references depends on the locations of the source ranges.
However, linking formulas may consume more memory than you want—especially when you're dealing with several large ranges of data.
Another way to summarize and manipulate data is by creating an Excel pivot table.
To select the first source range, activate its workbook, click the tab for the appropriate sheet, highlight the range by dragging over it, and click the Add button.For example, you can use the addition formula to find the average of those values.Summarizing information by using formulas is handy because you can update the summary calculation simply by recalculating the worksheet.If the ranges are in the same worksheet, you can simply specify the cell addresses.If the ranges are in the same workbook but in different worksheets, you must use sheet and cell references.
Search for examples of consolidating data in excel:
Don't bother including a source range's category labels when you specify the range—Excel won't include the labels in the destination.