Microsoft Excel features a data-consolidation function that allows several tables to be consolidated into a single summary report.Consolidating the data often facilitates easier editing and viewing of information since it can be seen in aggregate form as a master spreadsheet.There are three basic ways to consolidate data in Excel: by position, category and formula.

consolidating totals excel-43consolidating totals excel-6

The Consolidate dialogue box appears If the range of data is located on a different workbook, click the Browse button and locate the file This refers to where the labels are located in the source ranges The values from the source ranges are summarised using the chosen function on the consolidation sheet Using a formula to consolidate data is a more powerful method as you do not need to worry about any prescribed layout for the consolidating data, or ensuring they have the same labels.

The formula below sums the total cell on three different cells from three different worksheets.

B16) The consolidation will automatically update when the source data changes.

In this article, you will learn comparing two lists using Conditional Formatting. We will use Conditional Formatting using COUNTIF function to get the result.

Consolidation is the process of combining values from several ranges of data either from within the same or different workbooks.

It can be used to summarize data from different worksheets into master worksheet and create a report using a variety of calculations.

Consolidate is found under the Data Menu; Data Consolidate.

You can consolidate your data in three different ways.

The attached workbook shows the three examples of Consolidation.