Sum Quantity by multiple part numbers?

[SRK]

I am looking for a formula to sum the quantity of each part number in a list.
Example of my data:

PART NO QTY.
70164 10,000
70164 25,000
70165 5,000
70165 5,000
70166 5,000
70168 5,000
70170 25,000
70170 5,000

Thanks for your suggestions.

 

[Pecoflyer]

I am looking for a formula to sum the quantity of each part number in
list.
Example of my data:

PART NO QTY.
70164 10,000
70164 25,000
70165 5,000
70165 5,000
70166 5,000
70168 5,000
70170 25,000
70170 5,000

Thanks for your suggestions.

Hi have a look at SUMIF, PIVOT TABLES..

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste