Summing of values corresponding to the same text repeated in a column

i have a column contains products names and another column contains the prices of these products, in the products names column the product could be repeated,
i want to sum the costs of the repeated product

Example:

Product Name	Price
A	20
B	10
A	5
C	30
B	50
A	15
C	7

i want to search for the repeated product Name , and sum the corresponding values in the Price column
can any one help me please!

Best option would be a PivotTable. It would help to format the data as a Table & refer to the Table as the PivotTable source