Dynamic table with Autofilter & Subtotal

We often need to take out those un-wanted rows but we don’wan’t to delete them.
Today we will discuss two really simple things Autofilter and Subtotal

Take the sample data file from previous post

http://appliedexcel.wordpress.com/2008/07/24/

Apply Autofilter as follows

Dynamic table with Autofilter & Subtotal : Autofilter Example

Insert one row above the table

Dynamic table with Autofilter & Subtotal : Insert one row above the table

In Cell E1 type the Subtotal formula, remember we want to sum those values hence use option ‘9’

Dynamic table with Autofilter & Subtotal : Add Subtotal

Copy the formula for Cost & Agent Fee and we are already there!

Dynamic table with Autofilter & Subtotal : Finish

Try changing the Autofilter category, you’ll see that the Total will change consequently to the filtered table.

Tags: Autofilter, Cells, Excel, Excel Formula, Formula, OpenofficeCalc, Subtotal