Explanation

The Subtotal feature automatically calculates summary values for groups of related records.

It is useful for calculating:

• Sum
• Average
• Count
• Maximum
• Minimum
• Product

for grouped data.

Go to:

Data → Outline → Subtotal

Example

Suppose sales data contains multiple cities:

You can calculate a subtotal for each city.

Practice

Create a sales table with at least three cities and identify the column that should be summarized.