Sum with filters applied

[Ehsanuls55]

You can use the SUBTOTAL or AGGREGATE functions to sum only the visible cells in a filtered data set. These functions specifically handle filtered data.

Let's break it down.

Applying filters
Step 1 : Select the data column to which you want to apply the filter.

Select 'Region' column : How to sum a column in Excel

Selecting the "Region" column

Step 2 : Go to the “Data” tab and click the “Filter” button.

Find 'Filter' in Sort and Filter : How to Sum a Column in Excel

Find 'Filter' in Sort and Filter

Step 3 : You will see drop-down arrows appear in the column headers. Click the drop-down vp financial email list arrow in the "Region" column and select the sections you want to display. For example, 'South'

You can sort sections alphabetically, by color, or by other criteria.

How to sum a column in Excel

Sort the selected column based on specific criteria

Press the 'Accept' button to get your answer.