Advantage of partial sums function
- With the subtotals feature, you can download individual sections in an Excel spreadsheet easily add up without any complications for the following calculations.
- The individual partial sums of the function as such, and in a list of long values are not double-counted. So stay between results can be identified as such.
- Also, the subsequent Paste of Numbers is not a Problem. Without the function of the Insert would cause a large error, and then a lot of effort.
Excel: Subtotal calculate
In the following example, we will perform the partial-sum calculation on the basis of an example. We sum up the individual amounts from a quarter, and create for each month a Subtotal.
- First, we create our table. Here all the values are in a row. After every fourth entry of a partial sum is calculated at the end of the entire sum (see picture).
- For the first part of the sum, we need the command "=SUBTOTAL(9;C5:C8)". Hereby, the partial result of the fields C5 to C8 is calculated. The 9 stands for the Summing up. This command can now be performed for all the sub-totals.
- For the total sum, we have the command "=SUBTOTAL(9;C5:C19)" is used. So all the Numbers are added together, the subtotals, however, are skipped.
Excel: Subtotal calculate
How to use the Excel auto sum use, we will show you in the next tip.
