| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spreadsheets--Adding Quantities
If I have two different worksheets, lets say spare mechanical parts, that
list the part number in 1 column and the quantity in stock in another column. Is there a way to bring them together so that the quantities of any duplicate part numbers will add up? For instance if on 1 spreadsheet I have Part# 1234 with a quantity of 5 and on the other spreadsheet I have the same Part # 1234 but with a quantity of 10; I want to bring those together on 1 spreadsheet so that Part # 1234 has a quantity of 15. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| More problems linking spreadsheets | Excel Discussion (Misc queries) | |||
| Linking spreadsheets | Excel Discussion (Misc queries) | |||
| Adding cells with different quantities and pricing but displaying | Excel Discussion (Misc queries) | |||
| Adding rows in linked spreadsheets | Excel Discussion (Misc queries) | |||
| Combine information about products from 2 spreadsheets | Excel Worksheet Functions | |||
Threaded Mode
