Filter and sum
Filter and sum
(OP)
Hi,
I use a filter on a table to sort parts by reference. on the next column is the price of the parts. When I sort parts by ref I would like to have Excel calculate the sum of the displayed prices only and not the full column of prices.
I'm looking for a function to do so, but if it can only be done by a macro, it's fine as well.
Many thanks,
I use a filter on a table to sort parts by reference. on the next column is the price of the parts. When I sort parts by ref I would like to have Excel calculate the sum of the displayed prices only and not the full column of prices.
I'm looking for a function to do so, but if it can only be done by a macro, it's fine as well.
Many thanks,
Cyril Guichard
Mechanical Engineer
RE: Filter and sum
SUB.TOTAL(9,ref1,ref2,...)
Cyril Guichard
Mechanical Engineer
RE: Filter and sum
Rick Kitson MBA P.Eng
Construction Project Management
From conception to completion
www.kitsonengineering.com
RE: Filter and sum
Cyril Guichard
Mechanical Engineer
RE: Filter and sum
TTFN