| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum a quantity once for multiple entries
I am using Office 2003 on Windows XP.
Suppose I have the following (hopefully it will line up): ID Qty 232 50 232 50 232 50 628 10 628 10 550 63 728 82 009 14 009 14 Is there a formula I can use in the spreadsheet that will sum the quantities (Qty) column, but only once for each ID? If so, could someone please post a solution? I could code something in VBA, but I'd prefer to write a formula. Can it be done? Thanks much in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum Quantity by multiple part numbers? | Excel Discussion (Misc queries) | |||
| Need a formula to increase quantity of one cell until the quantity ofanother is exceeded | Excel Discussion (Misc queries) | |||
| Combine Multiple Entries with differing amounts of entries | Excel Worksheet Functions | |||
| printing multiple worksheets with different specified quantity. | Excel Programming | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
Threaded Mode
