Spreadsheets--Adding Quantities

[Guest]

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.

 

[Bernard Liengme]

Are the part # and quanties in the same columns in the various sheets?

 

[Guest]

No they are not at the moment. I could try to do that, especially if it
saves some work!

 

[Guest]

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]

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