Sum Quantity by multiple part numbers?
 

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.

Sum Quantity by multiple part numbers?
 

SRK;225678 Wrote:
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.

Hi have a look at SUMIF, PIVOT TABLES...


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=62638