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.
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 ...