Summing a filtered List

zoot · Dec 25, 2004

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 · Dec 25, 2004

zoot,

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

=SUBTOTAL(9, A2:A6)

zoot · Dec 25, 2004

Thanks ur awesome

Earl Kiosterud said:
zoot,

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

=SUBTOTAL(9, A2:A6)