I am trying to find a formula that will search another worsheet for a
specific text (product) and also sum up the quantitys used. The items may
appear on the same spreadsheet more tnan once so I will need to use a range
of A1:A500 to search for the product number, then total the quantities in the
adjoining cell, even if it appears more than once on the same spreadsheet.

e.g.

House no. DEVELOPMENT
ESP1234N 15 29 READING
NHB5669 9 5 MILTON KEYNES

I have 5 workbooks for each day of the week and Im aiming to summarise the
quantity's used for each item in a 'stock movement' summary.

I only need the first two colum results for the stock movement summary report.

Please help, this is driving me nuts :(