On 2002-04-18 12:52, Drew wrote:
I find it useful to put a subtotal formula above labels so that your subtotals don't expand or contract when filtering a list.
ex. labels start on row 3, A3=date, B3=type, C3=pymts, D3=deposits
In c2 put =subtotal(9,c4:c200) and in d2 put =subtotal(9,d4:D200)
You can filter on any column now and get the appropriate total.
HTH
Drew


[ This Message was edited by: Drew on 2002-04-18 12:53 ]

[ This Message was edited by: Drew on 2002-04-18 12:55 ]
Hi Drew:
That's pretty neat way of having the pertinent data visible all the time.

Regards!

Yogi Anand