![]() ![]() If you later change values in this column, Calc will automatically recalculate the subtotals. In the Calculate subtotals for box on the First Group page, select a column containing values to be subtotaled. Entries in the cell range from step 1 will be grouped and sorted by matching values in this column. In the Group by drop-down list on the First Group page, select a column by its label. Alternatively, click on a single cell within your data to allow Calc to automatically identify the range.Ĭhoose Data - Subtotals to open the Subtotals dialog. Select the cell range for the subtotals that you want to calculate, and remember to include the column heading labels. To insert subtotal values into a worksheet:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |