Excel 2010 allows you to automatically add subtotal rows when you want to break your numbers into categories defined by a particular column. For example, if your rows contain individual basketball players' scores for each game, Excel can create separate subtotals for each player showing their season totals, as long as the player names are in the same column. Before you can create the subtotals, you must sort your data by the column you plan to use for your categories.
Sort Data By Column
Click anywhere in the Excel data containing the numbers you want to subtotal.
Click "Sort & Filter" on the Home tab, and then select "Custom Sort" to open the Sort dialog box.
Change the "Sort By" setting to the column containing your subtotal categories. For the example, when finding season totals for individual basketball players, select the column that contains the players' names.
Click "OK" to sort the data.
Create Subtotal Rows
Click anywhere in the data again.
Select the "Data" tab, and then click "Subtotals" to bring up the Subtotal dialog box.
Change the "At Each Change In" setting to the name of the column that contains your subtotal categories. Select the same column you chose earlier to sort the data.
Check the box in the "Add Subtotal To" field that corresponds to the column containing the numbers you want to subtotal. For the previous example with the basketball players, select the column that contains the number of points per game.
Click "OK" to create the subtotals. Excel displays the subtotals in new rows after each category.
- Pixland/Pixland/Getty Images