Hello,

I have a workbook containing 3 sheets.
On sheet 1 in column A, I have reference numbers from 1 to 20. The
totals for these rows are in column I.
On sheet 2 in column A, I have reference numbers from 1 to 20. The
totals for these rows are on column L.
Sheet 3 is a summary sheet.
I need to do the following. Look for all occurances of ref 16 in sheet
1 and add up the corresponding figures in column I, then look for all
occurances of 16 in sheet 2 and add up the corresponding figures in
Column L to give me an overall sum total of all occurances of 16 in
both sheets.

I hope this is clear. Thanks in advance for any help.

Ket
London (UK)