Duplicates - How to sum

[magicpanda]

Hi I'm sure this is very basic but I'm trying to find a way to add together all duplicate entries.

I've attached an example of a dummy manifest showing in Column A the product SKU number, in Column B the product name and in Column C the number of units in each carton.

As you can see the SKU for "Toy A" reoccurs multiple times. What I want to know is how do I sum together all the "Quantity's" for each SKU?

In practice I will be doing this for over thousands of different SKU's so using the SUMIFS function just doesn't seem practical from the examples I've researched.

I hope that makes sense....

[RChad]

Hi,

I used a helper column to get the unique Products using this formula:

Please Login or Register  to view this content.

Press CTRL+SHIFT+ENTER to make it an array

Then in next column this formula:

Please Login or Register  to view this content.

Then to get SKUs

Please Login or Register  to view this content.

In all cases drag down your range needed for the number of Products.

[CARACALLA]

E3=SUM(IF(FREQUENCY(IF(B3:B100<>"",MATCH(B3:B100,B3:B100,0)),ROW($B$3:$B$100)-ROW(B3)+1),C3:C100))

Control+shift+enter

[TMS]

Suggest you use a Pivot Table.