Page 53 - Dig_CodeAI_V2.1_Class_7
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
   48   49   50   51   52   53   54   55   56   57   58