Page 44 - Computer Genius Class 07
P. 44
Using Subtotal Command
The Su total command allo s you to calculate group ise sum. t also calculates the grand total at
the end. e ore using the Su total command data must e sorted in ascending or descending order.
Perform the following steps to use the Subtotal command:
2 Click on the Data tab. 3 Click on the Subtotal command.
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 do n list.
5 Select the Count
function from the Use
function drop do n 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 remo e su totals clic on Subtotal command and click on the Remove All button.
42 Computer Genius-VII

