Hi

I have a dokument with storage figures and i need to sort them.
The problem is that one type of product can be found in several rows under
different numbers and price. The document has SEVERAL 100 OF PRODUKTS.

For exampel:

prod nr
1245 candy 123$
1245 candy 321$
4512 candy 213$

What i need is to sum this 3 rows to 1 row and get the total value of of one
kind of produkt, in this case "candy"

Result: candy ***$

Please advise im lost !!