Page 53 - Digicode_AI_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:

                                         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-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 and click on the Remove All button.




                                                                        Advanced Features of Excel 2016   51
   48   49   50   51   52   53   54   55   56   57   58