Filter and sum

FrenchCAD · Jun 13, 2003

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 · Jun 13, 2003

nevermind, i found it

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

Cyril Guichard
Mechanical Engineer

RDK · Jun 13, 2003

sumif may also work

Rick Kitson MBA P.Eng

Construction Project Management
From conception to completion

http://www.kitsonengineering.com

FrenchCAD · Jun 16, 2003

Will check it. Thanks for the tip.

Cyril Guichard
Mechanical Engineer

IRstuff · Jun 16, 2003

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

TTFN

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Filter and sum

FrenchCAD

Mechanical

FrenchCAD

Mechanical

RDK

Civil/Environmental

FrenchCAD

Mechanical

IRstuff

Aerospace

Similar threads

Part and Inventory Search

Sponsor