Microsoft Office Tutorials and References
In Depth Information
Add a Column Subtotal
Add a Column
Subtotal
You can get more out of your table data by summarizing
a field with a subtotal that appears at the bottom of
the column.
Although the word subtotal implies that you are
summing the numeric values in a column, Excel uses
the term more broadly. That is, a subtotal can be not
only a numeric sum, but also an average, a maximum
or minimum, or a count of the values in the field.
You can also choose more esoteric subtotals such as
a standard deviation or a variance.
Add a Column Subtotal
1 Select all the data in the
column you want to total.
Note: See “Select Table
Data,” earlier in this
chapter, to learn how to
select column data.
2 Click the Quick Analysis
smart tag (
).
Search JabSto ::




Custom Search