Spreadsheets--Adding Quantities

W

WhiteS

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.
 
W

WhiteS

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

WhiteS

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?
 
B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with time function 7
Function Problem 6
use month in cell date to sum all relevant cells 2
Consolidation Table from Different Excel Tabs with Different Format 1
Document Merge Formatting Issue 0
create manufacturing demand based on customer delivery 0
Creating a Chart on form from selected data in query. 0
Need Formula For Data Summary 7

Top