Merge two Excel 2000 spreadsheets

[Marikallees]

I have an inventory spreadsheet with three pages. Is there a way to
merge two copies of the spreadsheet such that the resulting spreadsheet
will have the sum all of the inventory totals in both copies without
changing anything else?

For example:

Spreadsheet 1:
1234 Item1 250 2345 Item2 39
3456 Item3 900 4567 Item4 22

Spreadsheet 2:
1234 Item1 75 2345 Item2 27
3456 Item3 450 4567 Item4 13

Merged Spreadsheet:
1234 Item1 325 2345 Item2 66
3456 Item3 1350 4567 Item4 35

Thanks for your time.

 

[Frank Kabel]

Hi
are the item names on all sheets always in the same position?

 

[Marikallees]

Yes. The product codes are in columns A and E, the item names are in
columns B and F, and the inventories are in columns C and G. This holds
true for all three sheets.

 

[Frank Kabel]

Hi
the on your summary sheet use the following for example in C1
=SUMIF('sheet1'!A:A,A1,'sheet1'!B:B)+SUMIF('sheet2'!A:A,A1,'sheet2'!B:B)

 

[Marikallees]

I'm not very experienced with Excel, how would I go about setting up
this summary sheet and running the formula? Do you have any reference
links that might help me to understand how to do this?

 

[Frank Kabel]

Hi
you should start with entering the product ID's and names on your summary
sheet. Then apply this formula on this summary sheet

 

[Marikallees]

Unless I'm missing something, that's way to involved for my users to
handle. It would be faster and easier to hand-type the totals than to
ask relatively computer illiterate people to run that formula.

 

[Frank Kabel]

Hi
but then you risk that they 'handtype' wrong totals.