Help with a spreadsheet - comparing data

[DMSPaul]

Hi there, hope someone can help.
I've got a spreadsheet which has 4 sheets:
1 Reserve Stock (RES STOCK), 2 Available Stock (AVL STOCK), 3 Bul
(BULK) and 4 Variance (VARIANCE).
In each sheet is a list of product codes and their various quantitie
(sheet 4 is blank).
I want to add up the quantities for each code from sheets 1 and 2 an
compare the result to sheet 3, displaying the results on sheet 4.
Note, not all codes will appear on all 3 sheets.

Quick example:

Sheet 1
Code = ABCD112
Qty = 5

Sheet 2
Code = ABCD112
Qty = 22

Sheet 3
Code = ABCD112
Qty = 28

Sheet 4
Code = ABCD112
Match = No Match (or similar)

Thanks a lot

Pau

 

[Frank Kabel]

Hi
as you did not provide much detail about your spreadsheet layout lets
assume the following:
- on sheet 1/2 you have in col. A the product code and in col. B the
quantity
- same is true for sheet 3
- on sheet 4 you already have a list of all valid product code in
column A

Enter the following in B1 on sheet 4 to sum sheet 1 and sheet 2:
=SUMIF('RES STOCK'!$A$1:$A$1000,A1,'RES STOCK'!$B$1:$B$1000)+SUMIF('AVL
STOCK'!$A$1:$A$1000,A1,'AVL STOCK'!$B$1:$B$1000)

In C1 you can enter the difference of sheet 3 and the sum of the first
sheets. enter the following in C1
=SUMIF('BULK'!$A$1:$A$1000,A1,'BULK'!$B$1:$B$1000-B1

 

[DMSPaul]

Thanks.
Sorry yes, I didn't give the layout, but I can adjust as necessary.
The only problem is, I don't have any 'master list' of product codes s
may have to just make up that list manually with lots of copying an
pasting

Thanks again.

Pau