How to SUM Only Visible (or Filtered) Rows Using SUBTOTAL

Filtering Data Table Rows

Now, let’s try filtering our data to see what happens with the Total row. Click on the down button next to the Region column. In the drop-down menu, select only the West region and click OK.

Filter Region

As a result, the table will now only show the rows that are from the West region. Unfortunately, the Total row still shows the total for the entire table – including the rows hidden by the filter!

Filtered Total Broken