Hi Bernard,

Many, many thanks the =SUMIF(B:B,B1,I:I) did the trick very nicely.

Kind regards,

Simon.

"Bernard Liengme" wrote:

In K1 enter =SUMIF(B:B,B1,I:I) ( that is the letters I,
colon , letter I)
Copy down the column
Of course, you will get duplicates

If you had a list of unique product codes starting in K1, then in L1 use
=SUMIF(B:B,K1,I:I)
and copy down to the last K value

But Pivot Tables are ideal for this type of work.
Read a few of these and then come back with questions

http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.techonthenet.com/excel/pivottbls/index.htm
http://www.dicks-blog.com/archives/2...le-parameters/

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"SiH23" wrote in message
...
In Column B I have listed various product codes, these codes are a mixture
of
both alpha and numerical characters, some are duplicated several times in
the
column.

Each product code has an associated payment total in £ sterling in Column
I.

I would like to place a formula in Column K which will show the associated
payment 'total' for each product code.