To add subtotals based on multiple columns, as shown in Figure 1,
sort the dataset by the desired columns and then apply the subtotals,
making sure Replace Current Subtotals is not selected. The subtotals
should be applied in order of greatest to least. For example, if the
data is sorted by Region, with the products within each region sorted,
apply the subtotal to the Region column and then the Product column.
Subtotaling by Multiple Columns
To subtotal by multiple columns, as shown in Figure 1, follow these steps:
1. | Sort the data by the columns the summary should be based on.
|
2. | Select a cell in the dataset.
|
3. | Go to Data, Outline, Subtotal.
|
4. | From the At Each Change In field, select the major column by which to summarize the data.
|
5. | From the Use Function field, select the function to calculate the totals by.
|
6. | From the Add Subtotal To field, select the columns the totals should be added to.
|
7. | Click OK.
|
8. | Repeat steps 3 to 7 for the secondary column. |