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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spreadsheets--Adding Quantities
Are the part # and quanties in the same columns in the various sheets?
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "WhiteS" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spreadsheets--Adding Quantities
No they are not at the moment. I could try to do that, especially if it
saves some work! "Bernard Liengme" wrote: Are the part # and quanties in the same columns in the various sheets? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "WhiteS" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spreadsheets--Adding Quantities
Ok, so actually what I am trying to do is match up Part#'s w/ their
descriptions in two different worksheets. Sorry for the confusion! Any way to do this? "Bernard Liengme" wrote: Are the part # and quanties in the same columns in the various sheets? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "WhiteS" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spreadsheets--Adding Quantities
Have you looked at VLOOKUP and SUMIF?
Tell us how the data is set out on each sheet. Tell us what result you are looking for. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "WhiteS" wrote in message ... Ok, so actually what I am trying to do is match up Part#'s w/ their descriptions in two different worksheets. Sorry for the confusion! Any way to do this? "Bernard Liengme" wrote: Are the part # and quanties in the same columns in the various sheets? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "WhiteS" wrote in message ... 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. |
Reply |
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 |