![multiple subtotals in excel 2010 multiple subtotals in excel 2010](https://www.get-digital-help.com/wp-content/uploads/2014/04/Subtotal-feature.png)
You can insert subtotals in Microsoft Excel data sets or lists using the Subtotal feature (which appears on the Data tab in the Ribbon) to summarize data.
![multiple subtotals in excel 2010 multiple subtotals in excel 2010](https://www.avantixlearning.ca/wp-content/uploads/2018/09/Remove-all-button-in-Excel-Subtotal-dialog-box.png)
by Avantix Learning Team Updated April 9, 2021.
#MULTIPLE SUBTOTALS IN EXCEL 2010 PLUS#
This works because our individual monthly ranges PLUS the subtotals is exactly equal to 2 times the individual monthly ranges. 10 Useful Tips for Summarizing Data Using Excels Subtotal Feature.
![multiple subtotals in excel 2010 multiple subtotals in excel 2010](https://images.squarespace-cdn.com/content/v1/5b66f7584611a0958c39511d/1622310853159-7GNO66OM7OHRL29M8KDE/ExcelMultiRowHeader1.png)
Notice that the /2 is outside of the Sum brackets – that tells Excel to Sum the range D2 to D28 first, and then divide the total by 2. Then, divide it by 2 by typing in a /2 at the right side of the formula (either in the cell directly or in the formula bar above your columns as shown below.) The shorter way, and the trick I learned just last year, is to highlight the entire range for your Sum formula, i.e., =SUM(D2:D28).
![multiple subtotals in excel 2010 multiple subtotals in excel 2010](https://media.gcflearnfree.org/ctassets/topics/175/outlining_subtotal_command.png)
You could use your mouse to highlight either each of the subtotals or each of the individual ranges, using a comma between each range as we discussed last week. The long way would be to use the AutoSum button as above, to create the SUM formula in cell D29. If this happens, there are two ways to deal with it. It may also have this problem with columns on occasion, and would suggest the formula, =SUM(D2:D28) instead. It takes the function number of corresponding functions as an argument and location of cells to show you the subtotal of the selected data range. Excel 2010 offers SUBTOTAL function that provides users with a list of functions that can be used by only entering their function number. However, if your range is across a row instead of down a column, Excel may have a harder time picking up the subtotals. Remembering all the functions that Excel 2010 provides is not possible, but you should know all basic functions, so that you can quickly apply them. Sometimes, Excel is smart enough to figure out that you have subtotals in the range and it will automatically create a formula such as, =SUM(D9,D20,D28). You’ve gone to the trouble of putting totals at the bottom of each month, such as in the following example:Īs we discussed last week, you could use the AutoSum button to put a SUM formula in D29. Some of you have probably already thought of this, but for those of you who haven’t… The image above demonstrates the Subtotal tool applied to cell range B2:E30. That is, I would like the values in the first subtotal row to be (9+10)/2 (40+35)/2 and (28+24)/2 and in the second subtotal row to be (11+11+10)/3 (30+25+25)/3 and (24+19+20)/3.This is one of those tricks that is so simple that I groaned when I heard it. The Subtotal feature lets you insert totals and grand totals automatically, this feature was added to Excel 2010 and is still around in later Excel versions. Is there any way to calculate the average sale value per day, instead of calculating the average sales value per line entry in every week? However, when trying to calculate the average sales per day (in each week), the average sales per line entry is give. The sum subtotals in an Excel pivot table are calculate as expected, with the correct sales totals per week (the line entries sum up to total sales for a day and the daily totals sum up correctly to weekly totals). In the sample data provided there are multiple line entries per day as well as multiple days per week.