Running total of visible values in a filtered table (2007)

Hello Everyone,

[The spreadsheet originally attached to this first post contained an error. Please reference the revised spreadsheet contained in the 2nd post. Thx!]

My problem is: I have a data table with all my data in it. I want to be able to filter the data, and have a column automatically calculate a running (or aggregate) sum of the filtered (visible) information in a particular column of the table.

If you glance at the attached sample spreadsheet (in 2nd post!), you will quickly see what I mean. I am searching for a formula for column L that will caculate a running sum for column K. In column T, you can see the results that I'm looking to reproduce in column L. Each cell in column T simply adds the K column value for that row to the previous value in column T (the cell above). However -- to my knowledge, and as in this case -- the formula for column T can only be copied down the column AFTER the table has been filtered.

Rather, I am looking for a formula for column L that will *automatically* create this running sum depending on how I filter the table.

I do know how to use the SUBTOTAL function to sum filtered information. However, I don't see how to use SUBTOTAL to calculate a running sum since SUBTOTAL results (apparently) can't be added together.

To summarize, I'm looking for a formula for column L that will calculate the correct results irrespective of how I filter the table.

Ideas, anyone?

Cheers,

Jay

Unfilter table, insert below to populate table cells, then set filter accordingly:

L7: =SUBTOTAL(9,$K$6:$K7)