Page 215 - TP_IT_V1.0_C10_flipbpookl
P. 215

Let us take an example of counting the strength class-wise using subtotal as shown in the given spreadsheet:

































                 To insert Subtotals values into a spreadsheet, follow the steps given below:

                 Step 1:   Select the range of cells. Ensure that the column labels are created and selected in the range. In the above
                         sheet the range is A1:C13.
                 Step 2:  Select the Data   Subtotals option from the Menu bar.

































                         The Subtotals dialog box opens with the option of 1st Group tab.

                 Step 3:  Select the Class option from the Group by drop-down menu.
                 Step 4:  Select Section check box in the Calculate subtotal for list box.

                 Step 5:  Select the Count function from the Use function list box.



                                                                      Electronic Spreadsheet (Advanced) using LibreOffice Calc  213
   210   211   212   213   214   215   216   217   218   219   220