Consolidating sheets excel 2016
In this article, we'll show you the simplest way to use the Consolidate... In a future article, we'll demonstrate a more complex use of the Consolidate... Consolidating by position Creating links to the source data Specifying multiple-cell destination ranges Conclusion You can consolidate by position if all the source ranges (the ranges containing the data you want to consolidate) are the same size and the data is arranged in the same order.
That is, you use it to count the values in multiple ranges or to find the sum, product, minimum, maximum, variance, standard deviation, or average of the values in a group of ranges.
Before you begin, it's a good idea to open the workbook(s) containing the ranges you want to consolidate.
For example, the ranges shown in Figure A are on different worksheets in the same workbook.
If the ranges are in the same workbook but in different worksheets, you must use sheet and cell references.
If the ranges are in different workbooks, you must use book, sheet, and cell references.