| 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. |
| 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 | |||
Threaded Mode
