Filtered lists subtotal

B

beluga

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.
 
F

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
Click to expand...
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
Click to expand...
the above list, the last value (date) of Column A.
 
Top