I wanted to include an image but I can't seem to do that here?

anyways what I do is

1. Move the Product code to column A (required for formula)

2. Click Column A to select

3. Click menu>> Data/Filter/Advanced Filter

4. Check the options as follows
a) Copy to Another Location
b) Check Unique records
C) In "Copy To" put the cell reference of the first blank cell to the far right of your Data eg if G1 put in $G$1

5. Click OK and your List should only include single occurances of your Product

6. you need to use this formula, but keep in mind your range may be wider than I am specifying.

=SUMIF(A:C,G1,C:C)


A:C is the range of your original Data (not your unique list just created)

G1 is the first Unique cell of the new list

C:C is the Solumn that contains the data to sum


note the Advance Filter needs to be applied within the same sheet, but you can copy it seperatly after