Consolidating Data

The Consolidation feature is used to take data from multiple sheets and consolidate it into one sheet. For example, you may want to take your sales figures from a number of years and consolidate them into one spreadsheet where an average value (computed from the data in each yearly summary sheet) appears as the sales value for each product or region. Figure 9.3 shows the first quarter sales figures for two years (1999 and 2000) that have been consolidated as an average into a consolidation table.

Figure 9.3. Data can be consolidated from multiple tables into a consolidation table.

To Name Areas for Consolidation

Since you will ...

Get StarOffice™ 5.2 Calc Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.