![how to subtotal data in excel and show only the result how to subtotal data in excel and show only the result](https://cdn.extendoffice.com/images/stories/doc-excel/calculate-cumulative-sum/doc-calculate-cumulative-sum-3.png)
How to subtotal data in excel and show only the result how to#
Related: How To Create a Pivot Table in Excel 2. You can add various columns that you want to calculate subtotals for, but if you only want to calculate a subtotal for one column, ensure that column is farthest to the right. Create the table where you want to include a subtotal. Here's how to use the subtotal function in Excel in a table: 1. Related: 8 of the Best Sales Jobs You Can Pursue Without a Degree How to use the subtotal function in Excel in a table The formula counts the individual quantities for each color and ignores the subtotals to ensure an accurate result.
![how to subtotal data in excel and show only the result how to subtotal data in excel and show only the result](https://www.chelseadatamanagement.com/wp-content/uploads/2019/08/subtotals5.png)
Note that the subtotal function can also calculate the total number of T-shirt sales. You want to count how many of each color you sold, so you compile orders that indicate sales for blue, red and yellow T-shirts.īy using the subtotal function underneath each column, you calculate the sales for each color T-shirt. For instance, imagine that you have a company that sells T-shirts. The subtotal function in Excel shows totals for different groups. Related: Rules of Multiplication: Definition and Examples What the subtotal function in Excel can show you One of the most popular uses of the subtotal function is to calculate the sum of a column, but it can also perform the following operations: are the values you want Excel to include in the calculation. ), where function_num refers to the operation you want the formula to perform. It appears as =SUBTOTAL(function _ num, ref1. The subtotal function in Excel is a formula that calculates a range of values based on a specified operation. In this article, we teach three methods for using the subtotal function in Excel and provide step-by-step instructions. It's relatively easy to use in your spreadsheet and allows you to organize your data. The subtotal function in Excel is a practical way to calculate smaller amounts separate from the final total. While it can be beneficial to know the total sum of a spreadsheet column, you may want to know the totals of different groups.