unique records and summing quantites

[Ramzes]

Hi All,

I have got a problem with finding a formula to sort and sum products.

Most of formulas I thoght of are only counting number of times it appears or comes back with the number of the unique records under one product.

I have two columns
In the first one I have product ID Numbers
In the second column I have Product quantities.

Ex.
bmok1298 50
cmsh4365 100

bmok1298 75
dngl3487 250

What I was trying to do is sum the quantities of the unique records and avoid the blanks.

So It should come back as:
bmok1298 125
cmsh4365 100
dngl3487 250

The worst thing is that I don't know what the product ID's will be as it will change every time.

Is there any thing that can be done to achieve that.

It would be 1 cell will be serching for the unique product ID's and listing them one under another, where the second cell will be summing all the figures referred to the record found by the first one.

Or shall I try with some kind of macro?

Thank you for reading it and cracking your head over it.

Simon