Dynamic update of totals after filtering

Hi Guys,

I have an excel sheet in the following format.

Customer Name Location Bill Amount
ABC USA 100.00
XYZ USA 200.00
PQR UK 300.00
MNO UK 500.00
IJK INDIA 600.00
TOTAL 1700.00

I would like to filter on the location and I would like the TOTAL(at the bottom) to update dynamically. For Example, If i filter by location "USA" I want the first 2 records to be displayed along with the TOTAL which is equal to 100.00+200.00 = 300.00 $

Any simple way to achieve this???

Thanks in Anticipation!
Nani

Hello,

U shoul make use of Function 'Subtotal'
Insert one row on top of your data. Then in column 'Bill Amount' put following formula
=SUBTOTAL(9,C3:C7)
It is assumed that Bill Amounts are in range C3:C7 . Enter this formula in cell C1.

Hope this helps u.

Yup... this is what i was after.. Many thanks!