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