create ranked list of unique codes with subtotals

I have a list of products in column A and a list of values in a column B.
I need to create a third column, C, that uses a formula to return unique products from A
I also need a 4th column, D, that contains the sub totals from column B (probably a sumif)

To make it difficult I need column C and D sorted in descending order based on the subtotal in column C. If someone could incorporate a rank in the formula, that would be great and will save me manually sorting this table.

My preference is for standard formula's rather than arrays and VB.

I would appreciate any help you could provide.

Thanks

I have attached a basic example of data and what I hope excel can return. My real example is thousands of lines long but if I can get a formula that works I should be able to modify it.

Thanks. this did the trick!

Thanks. I learn't some new things by following your formula but the pivot table was a simpler solution in this instance.

thanks again.