Page 44 - Computer_Genius_v2.1_C7_flipbook
P. 44

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.





                       42    Computer Genius (V2.1)-VII
   39   40   41   42   43   44   45   46   47   48   49