Do you have a list somewhere of all the unique product codes? I'll assume its
in column J.
Placing this in K2:
=SUMIF(B:B,J2,I:I)
Will give you the total sum for the product code you have in J2.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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.