O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Subtotals to Analyze a List

Choose Data, Subtotals to apply aggregate formulas to groups of entries in a list. A typical application of the Subtotal command might be to add up sales by salesperson or customer, or expenses by payee or budget category. This command can do as its name suggests—add subtotal lines for each group of entries in a list. It also can supply other aggregate calculations at a group level. For example, you can use the Subtotals command to calculate the average of the values in a particular column for each group of rows, the number of rows in each group, the maximum or minimum value per group, the standard deviation for each group, and so on.

The Subtotals command provides one method for accomplishing these tasks. Another ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required