Growing Total using Autofilter in Excel?

[sdhunter9]

Hello,

I have a spreadsheet i am working on in Excel 2002. I have a ton of
data which i am sorting to date using AutoFilter, which is working
fine. when the data is not filtered i have a rolling total which adds
up the whole thing like this.

a b
1 100 100
2 100 200
3 150 350

but when i use the filter i see the larger totals in the list (which i
understand) What i want is the same thing in a new column, but for
only the current data from the view. example

a b
~
7 150 150
8 100 250
9 200 450

I have tried using sum and subtotal but it doesnt allow + example:
=sum(b7+a8) and =subtotal(9,b7+a8) I know the last example is illegal.

Does anyone know how to do this ?

 

[Guest]

I would copy the Autofiltered data over to a helper sheet and add the formula
there....

Vaya con Dios,
Chuck, CABGx3

 

[Bob Umlas]

Instead of using =SUM(A1:A1000), use =SUBTOTAL(9,A1:A1000) -- it will sum
only the rows which are showing because of the filtering!
Bob Umlas
Excel MVP

 

[Debra Dalgleish]

With headings in row 1, add this formula to cell C2, and copy down:

=SUBTOTAL(9,B$1:B2)