| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need a formula to increase quantity of one cell until the quantity ofanother is exceeded | Excel Discussion (Misc queries) | |||
| lookup part number in a vertical list and return the most recent . | Excel Discussion (Misc queries) | |||
| List all contracts that relate to a single part number | Excel Discussion (Misc queries) | |||
| Trying to generate a quantity from a list of doors with varying at | Excel Discussion (Misc queries) | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
Hybrid Mode
