SUBTOTAL Arguments
- The first argument is a number that tells Excel which summary function to use in the subtotal. The 109 in this examples tells Excel to use the SUM function. ...
- The second argument a reference to the range of cells that should be subtotaled.
How do you find the SUM of subtotals?
1. To get the subtotal of each group with the Sum function, see screenshot: 2. And then, sum the list values excluding the subtotals with this formula: =SUM(B2:B21)/2, enter this formula into a blank cell where you want to get the result, and then press Enter key to get the result you need.
How do you add subtotals using the SUM function?
How to Insert Subtotals
- Select or highlight the worksheet data.
- Go to the Data menu in the ribbon.
- Look in the Outline grouping of commands.
- Click on the Subtotal command and you'll notice a Subtotal dialogue box will open.
- In the Add subtotal to box, select Q1, Q2, Q3, Q4 and Year End.
