How to Create Subtotals in Excel
- 1). Create a column with similar data, such as prices. Create a second column that explains the data, such as the months in which each price existed.
- 2). Go to the "Data" tab on the toolbar that runs horizontally along the top of the screen. Click the top of the second column and select "Sort A to Z" in the "Data" tab.
- 3). Click "Subtotal" in the "Outline" group on the far right of the "Data" tab toolbar.
- 4). Select the type of subtotal you want to create using the "Use Function" drop-down menu. Excel lists "Sum" by default, meaning that the numbers will be added together. Other options include "Average" and "Product."
- 5). Check the box next to the column you want to sort by. In the above example, check the box next to "Months" to create a subtotal of prices in each month. Click "OK" at the bottom of the screen. In addition to creating subtotals for each month's prices, Excel also creates a grand total of the total of all prices.