| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need a formula to sum quantities by part number?
hi
sumif part# in A, qty in C. =sumif(criteria range, criteria, sumrange) =sumif(A1:A25,"70164",C1:C25) regards FSt1 "SRK" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need a formula to sum quantities by part number?
assumed col A - Part no.
Col B no. of items Col C Qty ordered Go to data | filter | advance filter | action : copy to another location | List range : sheet1!A$1:A$100 | copy to : E1 | check unique records only | ok in cell F2 put this formula =SUMIF($A$2:$A$6,E2,$C$2:$C$6) On Feb 11, 11:11*pm, SRK wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need a formula to sum quantities by part number?
Sounds perfect for a Pivot Table
"SRK" wrote: 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. |
| Reply |
| 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) | |||
Linear Mode
