![how to subtotal data in excel how to subtotal data in excel](https://www.officetooltips.com/images/tips/excel_button365/subtotal.png)
The resulting table below shows that we have successfully inserted subtotals in Excel, for Pen, Pencil and Marker.įigure 7. In summary, we want to insert subtotals that show the sum of sales for every item in our list.įigure 6. We choose Sales because it contains the values we want to subtotal. We choose Sum because it is the function that we want for the calculation of our subtotals. The Subtotal tool offers several functions like Sum, Count, Average, Max, Min, Product and even standard deviation functions.įor this example, enter the following values in the textboxes: Click Data tab, then Subtotal button in Outline Toolsįigure 4. Otherwise, we might come up with erroneous results for subtotals. Remember to include the headings in the selection. Select the whole list/database B2:D11įigure 3. Suppose we want to insert a subtotal for the sum of sales for each group of items in column B: Pen, Pencil and Marker.
How to subtotal data in excel how to#
This article shows how to insert subtotals in Excel for versions 2016, 2013 or lower.
![how to subtotal data in excel how to subtotal data in excel](https://cdn.extendoffice.com/images/stories/doc-excel/insert-subtotals/doc-insert-subtotals3.png)
The image above shows that we are able to summarize data in a range of data by inserting subtotals. Final result: How to insert subtotals in Excel Fortunately, Excel has a tool for subtotals that makes inserting subtotals in Excel so much easier.įigure 2.
![how to subtotal data in excel how to subtotal data in excel](https://cdn.wallstreetmojo.com/wp-content/uploads/2018/08/SUBTOTAL-Function-in-Excel-1.jpg)
However, this task could become tedious when handling large data sets. We can also use the Excel SUBTOTAL function, which offers several functions to be used to insert subtotals. Inserting subtotals can be done manually, where we insert a subtotal for each group of items in our list.