The full sheet is the same however just spread across around 4000 lines with changing references and product counts, I am wanting a generic formula that will work by suming the lines that match reference and product. I.e. duplicate lines. This is raw data and Due to the sheet this data is pasted into i cant have more than 1 of the same product under each reference but I need the total unit count of each product under each reference from this sheet.

If this is not enough information I can post the entire raw data on the 10th sorry for the delay.