i have the following table,
i would like to sum all duplicates quantaty , and if possible delete them after



any idea on how, i'm a rookiein excel

thanks in advaance

Product / qty

1 4040 300
2 4040 345
3 4209 165
4 4209 200
5 4263 178
6 4270 71
7 4305 106
8 4306 32
9 4306 -32
10 4602 350
11 4603 528
12 4603 90

PS, its a very long table , i tried an IF but it requires to entere each product , ant that will take long time

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