how to add multiple subtotals in excel to a final total

You can add multiple subtotaling functions to the same row, and you can add multiple rows.

We here at Learn Excel Now hope you found today’s tip on how to calculate a subtotal useful. There's more to Excel's Subtotal feature than you might realize. And the total changes with the information you select. However, watch what happens when you change the options using the Filter drop-down:Īs you can see, the Subtotal formula lets you find totals by Salesperson, Client, Product, etc. to add a subtotal to the right-most column (in this case, column C) at each change in the first. When you first enter this formula in cell D22, it gives you the total amount, the same as when you enter the Sum formula. How to add multiple subtotals in Excel 2016, 2013, 2010. For the spreadsheet example, we are looking for subtotals on the Sales column, Column D. Once the function is selected it’s time to enter the range. As you can see from the following menu, there are multiple functions to choose from: Note: You need to select which function you want the subtotal to use. So, how do you get the total to change with changes you make on the filter? This is where you will use the Subtotal formula. But, as you can see, once you use this formula and change the anything from the filtered drop-down menu, the sales total doesn’t change with it: This is the standard way to find a total. Select the field (s) to be used in the calculation from the Add subtotal to list. Select a calculation function from the Use function drop-down list. Select a field by which to group from the At each change in drop-down list. Now, if you wanted to find the sales total, you can use the following formula: Position the active cell within the data list. If you remember from last week’s blog post on Sorting and Filtering data, we have gone ahead and added the filter. Imagine you are running sales numbers using the following the spreadsheet: Today’s lesson is on using the subtotal formula to find various totals based on the filter option in Excel. If you know the right formulas and functions, you can find out just about anything you want to know about your data.

How to add multiple subtotals in excel to a final total