1st, 2nd, 3rd Group

Specify the settings for up to three subtotal groups. Each tab has the same layout.

To access this command...

From the menu bar:

Choose Data - Subtotals - 1st, 2nd, 3rd Group tabs.

From the tabbed interface:

On the Data menu of the Data tab, choose Subtotals - 1st, 2nd or 3rd Group tabs.

~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.

Using Subtotal Tool