Microsoft Office Tutorials and References
In Depth Information
In most cases, using a pivot table to summarize data is a better choice. Pivot tables are
much more flexible, and formulas aren't required. Figure 9-29 shows a pivot table cre-
ated from the data. See Chapter 18 for more information about pivot tables.
Figure 9-28: Use the outline controls to hide the detail and display only the summary rows.