I have data in a column from A2 down to around A800. The data is filtered by
auto filter.

I can get the sum of the visible data with =SUBTOTAL(109,A1:A1000). This
works just fine. Now I want to get the sum of only the last 7 visible
values. Problem is that I dont know how to put in the range because I dont
know it until after the filter is applied.

This is probably very easy, but excel help for subtotal does not cover it.

--
jake