Dynamic update of totals after filtering

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!