Microsoft Office Tutorials and References
In Depth Information
Summing with subtotals and grand totals
Summing with subtotals and grand totals
You frequently need to organize the data in an Excel worksheet
by one or more criteria. For example, you might have a
worksheet in which you list yearly sales for each product that you
offer, with the products broken down by category. If your data
is organized this way, you can have Excel calculate a subtotal
for each category of products. When you create a subtotal, you
identify the cells with the values to be calculated and the cells
that identify the change from one category to the next. Excel
updates the subtotal and grand total for you if the value of any
cell changes.
Create a subtotal
1 Click any cell in the range that you want to subtotal.
2 Click the Data tab.
3 In the Outline group, click Subtotal.
4 Click the At Each Change In down arrow.
5 Click the value on which you want to base the subtotals.
6 Click the Use Function down arrow.
7 Click the subtotal function that you want to use.
8 Select which columns should have subtotals calculated.
9 Click OK.
Search JabSto ::

Custom Search