sum and autofiltering

[moby]

I am using the autofilter on a spreadsheet for a simple checkbook. when i filter out everything buy ATM transactions I want to know the sum of those transactions only. Then When I filter for deposits I want the sum for only the deposits. How do I do this?

 

[Yogi Anand]

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