Lesson 221: Subtotal in Excel

This article will guide you to use Subtotal in Excel.

Subtotal

Use Excel’s SUBTOTAL function instead of SUM, COUNT, MAX, etc. to avoid rows being hidden by the filter or manually skipping hidden rows.

Rows hidden by Filter

1. For example, the SUM function below calculates total sales.

2. Apply Filter to

3. The SUM function includes rows hidden by Filter

4. The SUBTOTAL function ignores the rows hidden by the filter and calculates the correct result.

Hide rows manually

first. For example, the SUM function below sums a range of cells.

2. Hide 2nd row

3. The SUM function includes manually hidden rows.

The SUBTOTAL function ignores hidden rows manually and calculates the correct result.

In addition, you can also view many other excel articles here.