Consolidating data in excel 2016
The ranges can exist in the same worksheet, in different sheets in the same workbook, or in different workbooks.
Before you begin, it's a good idea to open the workbook(s) containing the ranges you want to consolidate.
Inside Microsoft Office 95 A Publication of The Cobb Group Published March 1997 Use this handy command on multiple ranges to calculate sums, averages, products, minimum and maximum values, and other statistical summaries.
Excel offers a number of ways to summarize information in different worksheets and workbooks.
If the ranges are in different workbooks, you must use book, sheet, and cell references.
If the source ranges are named, you can simply specify the ranges' names.
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.
Consolidating by position involves a few easy steps: First, you click on the upper-left cell of the range in which you want Excel to place the summary information (we'll call this range the range). However, you can choose from a variety of other statistics (Count, Average, Max, Min, Product, and so forth) if you want.
Since the source ranges are the same size, you don't have to specifically select the entire destination range. command from the Data menu to open the dialog box shown in Figure B. Once you've selected the statistic you want Excel to calculate, you should specify the source ranges.
Once the All References list box contains the addresses of all the source ranges, you should make sure that the Top Row and Left Column check boxes aren't selected.