Hi,
lets say you have in columng J a list of your codes for you want the totals
(starting in J2, in column K enter
=SUMPRODUCT(--(B:B=J2),I:I)

"SiH23" wrote:

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.