Note, that this consolidated table only contains static values.
Let’s say you want to insert a consolidated table in a blank worksheet…
This blog is started in 2007 and today has 450 articles and tutorials on using excel, making better charts.
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.
So, let’s go to our ‘North’ region file and select the range that includes the column and row labels.
I was wondering how to tabulate large amount of information gathered through surveys.
Where I work customers are constantly handed survey sheets in order for us to measure how the service -among other things- is being perceived.
Now, to put all that info into a spreadsheet (plus charts) can be really tedious.
It could also be in one or more different workbooks altogether.
Fortunately, there's another alternative: the Consolidate... You typically use it to perform summary calculations on values in corresponding cells in various source ranges.
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.
Each of four regions, North, South, East, and West have sales figures for all the products. Once cell ‘C4’ is highlighted, we go to ‘Consolidate’ in the ‘Data Tools’ section of the ‘Data’ tab in the ribbon.
The next order of business is to add our references for our consolidated table. Once there, we will go to our worksheet that contains the data for our North division.