Simple subtotals are calculated as follows (subtotal method):
- Prepare the data list and place the cell pointer within it. Decide which totals you need.
- Sort by the required field (for example, use the Sort dialog box, which opens when executing the Sort command located in the Sort & Filter group on the Data tab of the ribbon).
- Calculate the totals using the Subtotal dialog box (it opens when executing the Subtotal command located in the Outline group on the Data tab of the ribbon).
TIP
To remove subtotals, place the pointer in the list with totals and use the Remove All button in the Subtotal dialog box.
Now, let’s look at an example of calculating simple subtotals. Suppose we have a data list with the following fields:
No., Seller, Product, Batch Number, Price, Quantity, Total, Sale Date, Customer. The task is to determine the number of products sold by a specific seller.
To calculate simple subtotals, perform the following steps:
- Select the list (or simply place the cell pointer in the list) and sort it (execute the Sort command located in the Sort & Filter group on the Data tab of the ribbon) by the Seller field
- Use the Subtotal command located in the Outline group on the Data tab of the ribbon.
- In the Subtotal dialog box that opens, set the parameters according
and click OK.
- The resulting subtotals are shown :
