Filter and sum

[FrenchCAD]

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,

Cyril Guichard
Mechanical Engineer

 

[FrenchCAD]

nevermind, i found it

SUB.TOTAL(9,ref1,ref2,...)



Cyril Guichard
Mechanical Engineer

 

[RDK]

sumif may also work

Rick Kitson MBA P.Eng

Construction Project Management
From conception to completion

http://www.kitsonengineering.com

 

[FrenchCAD]

Will check it. Thanks for the tip.

Cyril Guichard
Mechanical Engineer

 

[IRstuff]

You might also want to consider using a pivot table for this

TTFN