formula to change when filtering

J

Jacob

Is there any way to have a calculation changed when using auto filter, based
on the filtered info?
I know it is possible with subtotals, but I want to have a runing total for
a bank register for multiple banks and when I filter the bank that I need it
should adjsut the runing total.
 
F

Frank Kabel

Hi
why not use the SUBTOTAL function. e.g.
=SUBTOTAL(9,B1:B1009)
to sum all visible values in B1:B100
 
Top