Summing a filtered List

[zoot]

If anyone can help!!...what I want to do is to sum up a column of a filtered
list after it has been filtered.

Column A Column B
1 March
2 March
3 April
3 May
7 June

Total 16
After filtering I end up with:

Column A Column B
1 March
2 March

Total 3

 

[Earl Kiosterud]

zoot,

Use the SUBTOTAL function with the sum spec (9). Something like:

=SUBTOTAL(9, A2:A6)

 

[zoot]

Thanks ur awesome

zoot,

Use the SUBTOTAL function with the sum spec (9). Something like:

=SUBTOTAL(9, A2:A6)