Sum Quantity by part number from a list?
 

What is the formula to sum various quantities by unique part numbers?
Partial list of data:

Part# # of Items Qty Ordered
70164 1 10,000
70164 1 25,000
70165 1 5,000
70165 1 5,000
70166 1 5,000
70168 1 5,000
70170 1 25,000
70170 1 5,000
70185 1 10,000
70186 1 10,000
70186 1 10,000
70187 1 25,000
70187 1 20,000
70187 1 25,000
70189 1 50,000
70189 1 20,000
70189 1 50,000


--
Thanks for your suggestions.

Sum Quantity by part number from a list?
 

Hi,

=SUMIF(A1:A100,70164,C1:C100)

or enter the part number in D1 and use

=SUMIF(A1:A100,70164,D1:C100)

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"SRK" wrote:

What is the formula to sum various quantities by unique part numbers?
Partial list of data:

Part# # of Items Qty Ordered
70164 1 10,000
70164 1 25,000
70165 1 5,000
70165 1 5,000
70166 1 5,000
70168 1 5,000
70170 1 25,000
70170 1 5,000
70185 1 10,000
70186 1 10,000
70186 1 10,000
70187 1 25,000
70187 1 20,000
70187 1 25,000
70189 1 50,000
70189 1 20,000
70189 1 50,000


--
Thanks for your suggestions.

Sum Quantity by part number from a list?
 

assuming that your data start at column A to C
and row 1 is your headers

the formula sum the quantities for part # 70189

try =SUMIF(A:C,70189,C:C) or

=SUMIF(A:C,D2,C:C)
where D2 is the cell you type the part # 70189

Looking at your data and its seem to be sort Ascending, if this is the
case you may want to use SubTotal, it will total up all the unique part#

1) Go to Data on the menu bar
2) select SubTotal
3) Choose Part# under At each change
4) Select Sum under Function
5) Select Qty Ordered under Add subtotal to
6) click OK

Hopr this help
--
Pls provide your feedback by clicking the Yes button below if this post have
help you. This will help others to search the archives for result better.


Thank You

cheers, francis





"SRK" wrote:

What is the formula to sum various quantities by unique part numbers?
Partial list of data:

Part# # of Items Qty Ordered
70164 1 10,000
70164 1 25,000
70165 1 5,000
70165 1 5,000
70166 1 5,000
70168 1 5,000
70170 1 25,000
70170 1 5,000
70185 1 10,000
70186 1 10,000
70186 1 10,000
70187 1 25,000
70187 1 20,000
70187 1 25,000
70189 1 50,000
70189 1 20,000
70189 1 50,000


--
Thanks for your suggestions.