Have you tried the 'SUMIF' function? It may do the trick.
--
T Tipsy


"Mike" wrote:

I have a worksheet containing three columns of data representing a list of
materials and quantities. The first column contains a Part Number, the second
column is a Part Number Name, and the third column is Quantity. Part Numbers
(and their associated names) repeat through out this listing.

I need to query the worksheet to determine what the total quantity of each
Part Number is, and on a second worksheet display in 3 columns; Part Number;
Part Number Name; and Total Quantity (where Total Quantity equally the sum of
all the same Part Number quantities). On the second worksheet only one
instance of each Part Number & Part Number Name should appear.

Any help would be appreciated.

Thanks