Page 284 - Excel 2013 All-in-One For Dummies

266 Consolidating Worksheets
Figure 4-14:
The Consolidated worksheet after having Excel total sales from the last three years.
Excel allows only one consolidation per worksheet at one time. You can, however, add to or remove source areas and repeat a consolidation. To add new source areas, open the Consolidate dialog box and then specify the cell references in the Reference text box and click the Add button. To remove a source area, click its references in the All References list box and then click the Delete button. To perform the consolidation with the new source areas, click OK. To perform a second consolidation in the same worksheet, choose a new destination area, open the Consolidate dialog box, clear all the source areas you don’t want to use in the All References list box with the Delete button, and then redefine all the new source areas in the Reference text box with the Add button before you perform the consolidation by clicking the OK button.
Consolidating by category
You consolidate worksheets by category when their source areas do not share the same cell coordinates in their respective worksheets, but their data entries do use common column and/or row labels. When you consolidate