Microsoft Office Tutorials and References
In Depth Information
If you keep related data in separate worksheets, or
for that matter, separate workbooks, you may
eventually want to consolidate. For example, if you
keep sales information for several regions on
separate worksheets, you may want to consolidate
the worksheets to find the total sales for all regions.
Excel’s Consolidate feature allows you to do just
that. Excel provides a variety of functions you can
use to consolidate including SUM, COUNT, AVERAGE,
MAX, MIN, and PRODUCT .
You start the consolidation process by selecting the
location for your consolidated data. You may want to
format your cells so that the incoming data displays
properly. You then select the function you want to
use to consolidate you data. The SUM function takes
the data from each location you specify and adds it
together. You tell Excel the location of the data you
want to consolidate. The data can be in the same
workbook or another workbook. Excel takes the data
and consolidates it.
Click in the top-left cell of the
range into which you want to
consolidate your data.
Click the Data tab.
l The Consolidate dialog box
Click here and select the function
you want to use to consolidate