sorted running balance
I think you mean "filter" a client.
See help on the SUBTOTAL function.
=SUBTOTAL(9,A1:A200) will total only visible rows after filtering.
Gord Dibben MS Excel MVP
On Tue, 18 May 2010 20:04:01 -0700, Dietrich
wrote:
i have a sheet with a running balance. This running balance is for all
clients.
I need a formula that will recalculate the running balance when i sort a
client.
The running balance formula keeps track of the hidden rows giving me a false
balance for that client. Need that to be able to print statement history
with running balance per client.
|