MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

trying to total a filtered field

  Asked By: Glenn    Date: Mar 01    Category: MS Office    Views: 1686

trying to build a material bill of materials. Column A is part number.
Column C is a Quantity. D is a designator whether it is an Assembly or a piece.
F is a drop down that you put in what asswmbly number it is associated with.
Column M is the weight of the piece. Now if it is an assembly I want it to first
locate on column F all pieces that our associted with it's part number, multiply
the quantity by the weight, total all pieces weights together, and return that
total back to it's weight field. Can anyone help me get this going. I'm not
having any luck.



1 Answer Found

Answer #1    Answered By: Marsha Miller     Answered On: Mar 01

Look at the 'Subtotal' function; that may get you what you need.

Didn't find what you were looking for? Find more on trying to total a filtered field Or get search suggestion and latest updates.