Microsoft Office Tutorials and References
In Depth Information
After you sort and group your data into categories
such as gender or age, you can perform a calculation
on each category. Excel provides the tools for
performing simple calculations to compare one
category with another. With a sort defined for at least
one column, you can find the average, sum, min, max,
number of items, and much more for that column or
another column. Excel calls the feature that enables
you to perform calculations on columns subtotaling,
even though you can use it to do more than subtotal.
Subtotaling uses outlining to hide data so you can
compare rows or columns. When you calculate the
average, sum, or other calculation for a sorted list,
outlining enables you to view only the results of the
Note that with subtotals, you can do a count on a
column with text entries. In other circumstances, the
COUNT function works only with numbers.
Click in a cell in your sorted list.
Click the Data tab.
The Subtotal dialog box appears.
Click here and select the
category by which you want to
Click here and select the type of
calculation you want to perform.
Click one or more columns to