Find duplicates in column A, add values from column B (possibly delete duplicates)

I am trying to find a macro that will find duplicates in a column, and then add all quantities in the next column for each duplicate. It can then either delete the duplicates, or just list the total quantity in a 3rd column. I have attached an example that includes the desired results. Any help would be greatly appreciated. Thanks.

It looks like it might be similar to the following thread, but I am too much of a beginner to know what to change.

http://www.excelforum.com/excel-prog...uplicates.html

hi luarwhite, option2, formula solution: D3 and drag down

Please Login or Register  to view this content.

For Option2, in D3 and drag down similar to watersev's method:
=SUMIF($B$3:$B$25,B3,$C$3:$C$25)

Thanks! That works for me!

For Option 1, copy that sheet and run:

Please Login or Register  to view this content.

Thanks again Kenneth. That works great!