The easiest way to take the sum of a filtered range in Excel is to use the following syntax:

SUBTOTAL(109, A1:A10)

Note that the value 109 is a shortcut for taking the sum of a filtered range of rows.

The following example shows how to use this function in practice.

**Example: Sum Filtered Rows in Excel**

Suppose we have the following dataset that contains information about various basketball teams:

Next, let’s filter the data to only show the players on the Mavs or the Warriors.

To do so, highlight the cell range **A1:B10**. Then click the **Data **tab along the top ribbon and click the **Filter** button.

Then click the dropdown arrow next to **Team** and then uncheck the box next to Celtics, then click **OK**:

The data will automatically be filtered to remove rows with “Celtics” as the team:

If we attempt to use the **SUM()** function to sum the points column of the filtered rows, it will actually return the sum of all of the original values:

Instead, we can use the **SUBTOTAL()** function:

This function takes the sum of only the visible rows.

We can manually verify this by taking the sum of the visible rows:

Sum of Points in Visible Rows: 99 + 94 + 93 + 104 + 109 + 84 = **583**.

**Additional Resources**

The following tutorials explain how to perform other common operations in Excel:

How to Delete Filtered Rows in Excel

How to Count Filtered Rows in Excel

How to Calculate the Sum by Group in Excel

How to Count by Group in Excel