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
   39   40   41   42   43   44   45   46   47   48   49