Using Microsoft® Excel® 2010

9. Subtotals and Grouping

This chapter shows you how data can be summarized and grouped together using Excel’s subtotal and grouping tools.

The ability to group and subtotal data allows you to summarize a long sheet of data to fewer rows. The individual records are still there, so that you can unhide them if you need to investigate a subtotal in detail.

Although the capability to create groups and outlines is not available in Excel Starter or Web App, workbooks with preexisting groups will still work as designed.

SUBTOTAL Function

The SUBTOTAL function calculates a column of numbers based on the code used in the function. With the correct code, SUBTOTAL can calculate averages, counts, sums, and eight other functions listed in Table 9.1. It ...