I feel the answer to my question is quite simple, but i cant seem to figure it out.

Column A: Column B:
Andy 70
Dave 50
Eric 40
Andy 30
Eric 50
Chris 10

How can i make Excel sum all numbers in Column B, where for instance 'Andy' is in column A. In other words, i wanna sum all of Andy's scores automatically.

Whats the easiest way to do this?