Tip 209 – Quickly Get Totals for Filtered Data in Excel

Configuring Excel data as a table lets you filter data and perform calculations on the filtered results. To do this, select your data (including headings), and choose Format Table from the Home tab on the ribbon. Right click the data, choose Table > Totals Row. Create a total for any column by selecting the calculation from the dropdown list in the last worksheet row. Now, when you filter the data, the calculations show results for visible cells only.