Using Multiple Summary Functions: MS Excel
- by Carol Bratt on 20070418 @ 12:29AM EST | google it | send to friends
- Filed under Carol's Corner Office | (related terms: data list, subtotal dialog box, box)
There can sometimes be situations when it is necessary to add more than one summary function to a list. For example, you may want to present both subtotals and averages for the groups within a data list.
To display summary functions follow these steps:
- Sort the data list on the field or fields by which the data should be grouped.
- Position the active cell within the data list.
- Choose Data | Subtotals.
- The Subtotal dialog box will appear.
- Specify options for the first subtotal.
- Choose OK.
- Choose Data | Subtotals.
- The Subtotal dialog box will appear again.
- Specify options for the second subtotal.
- Deselect Replace current subtotals if necessary.
- Choose OK.
That's all there is to it!
When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!
