Sum with Auto Filter On

[Robert P. Stearns]

Is there a way to sum a column with auto filter turned on?

A1: A B1: 1
A2: A B2: 4
A3: B B3: 7
A4: B B4: 1
A5: B5: =SUM(B1:B4)

If the first column is filtered by A the sum of column two equals 5.
If the first column is filtered by B the sum of column two equals 8.
Since A5 isn't A or B, B5 never gets displayed.

Thanks.

 

[Frank Kabel]

Hi
use SUBTOTAL. e.g.
=SUBTOTAL(9,B1:B10)

 

[Robert P. Stearns]

Works great! Thanks.

Hi
use SUBTOTAL. e.g.
=SUBTOTAL(9,B1:B10)