1st, 2nd, 3rd Group

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

За да пристапите до оваа наредба...

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.

Групирај според

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.

Пресметај суми за

Select the column(s) containing the values that you want to subtotal.

Користи функција

Select the mathematical function that you want to use to calculate the subtotals.

Using Subtotal Tool