I am sure there should be some formula in excel to use to get the result I want. I need a formula to look into one column and sum up totals from other column which have the same value in first column.

Example of data:

A 1000
B 5
A 300
A 72
B 41

The result I need to get:

A 1372
B 46

Meaning getting the totals of second column for the same value in the first column.

I would highly appreciate your help and hints.