Page 53 - ThinkGPT_V2.1_C7_Flipbook
P. 53
Using Subtotal Command
The Subtotal command allows you to calculate group-wise sum. It also calculates the grand total at
the end. Before using the Subtotal command, data must be sorted in ascending or descending order.
Perform the following steps to use the Subtotal command:
3 Click on the Subtotal command
2 Click on the Data tab. under the Outline group.
1 Select the
data on which
you want to
apply Subtotal
command.
4 Select the T-Shirt Size column from
the At each change in drop-down list.
5 Select the Count
function from the Use
function drop-down list.
6 Select
the column
from the Add
subtotal to list.
7 Click on the OK button.
The subtotal and grand total will appear.
To remove subtotals, click on Subtotal command under the Outline group in Data tab.
and click on the Remove All button.
Advanced Features of Excel 2016 51

