1st, 2nd, 3rd Group
Specify the settings for up to three subtotal groups. Each tab has the same layout.
To insert subtotal values into a table:
-
Ensure that the columns of the table have labels.
-
Select the table or the area in the table that you want to calculate subtotals for, and then choose Data – Subtotals.
-
In the Group By box, select the column that you want to add the subtotals to.
-
In the Calculate subtotals for box, select the check boxes for the columns containing the values that you want to subtotal.
-
In the Use function box, select the function that you want to use to calculate the subtotals.
-
Click OK.
~Grupo sipas
Select the column that you want to control the subtotal calculation process. If the contents of the selected column change, the subtotals are automatically recalculated.
~Llogarit nëntotalet për
Select the column(s) containing the values that you want to subtotal.
Shfrytëzo ~funksionin
Select the mathematical function that you want to use to calculate the subtotals.