Filtered lists subtotal

[Guest]

Hello,

I have a already filtered list with Column A: Dates, and Column B: numbers. I'd like each time I re-filter the list (custom filter - "less or equal to") up to a specific date in column A to get the subtotal of the numbers in Column B. But only the filtered numbers in Column B and not the whole column (fiiltered and unfiltered)

Also how can I have a cell showing every time I filter the above list, the last value (date) of Column A

Thank you.

 

[Frank Kabel]

Hi
have a look at the SUBTOTAL function. e.g.
=SUBTOTAL(9,B1:B100)

-----Original Message-----
Hello,

I have a already filtered list with Column A: Dates, and

Column B: numbers. I'd like each time I re-filter the list
(custom filter - "less or equal to") up to a specific date
in column A to get the subtotal of the numbers in Column
B. But only the filtered numbers in Column B and not the
whole column (fiiltered and unfiltered).

Also how can I have a cell showing every time I filter

the above list, the last value (date) of Column A.