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

