| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a formula to sum quantities by part number?
What is the formula to get the sum of quantities from a list of part numbers?
Example of my 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 I need a result showing each unique part number and the total quantity. -- Thanks for your suggestions. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula equation for a conditional number - PART 2 - said better | Excel Worksheet Functions | |||
| Manipulating Order Quantities with a Formula | Excel Discussion (Misc queries) | |||
| Look up part of a number within a serial number and cpy back assoc | Excel Worksheet Functions | |||
| Number formating in CONCATENATE formula (Part 2) | Excel Worksheet Functions | |||
| How do I convert numbers (quantities) en letters with a formula? | Excel Discussion (Misc queries) | |||
Threaded Mode
