| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum Quantity by part number from a list? | Excel Discussion (Misc queries) | |||
| Need a formula to increase quantity of one cell until the quantity ofanother is exceeded | Excel Discussion (Misc queries) | |||
| Looking up the same part numbers from multiple pages and listing e | Excel Discussion (Misc queries) | |||
| Lookup the same part numbers from multiple pages | Excel Discussion (Misc queries) | |||
| Replace Old Part Numbers with New Part Numbers in a Macro. | Excel Discussion (Misc queries) | |||
Hybrid Mode
