J
Jakobshavn Isbrae
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 don’t know how to put in the range because I don’t
know it until after the filter is applied.
This is probably very easy, but excel help for subtotal does not cover it.
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 don’t know how to put in the range because I don’t
know it until after the filter is applied.
This is probably very easy, but excel help for subtotal does not cover it.