L

#### lukasrichardhermann

can anybody tell me the fastest way as to how to calculate the following scenario:

I have 2 columns A + B and ca. 400 rows

In column A are names of people

In column B are numbers indicating how often the persons in column A have been named.

Eg:

A B

Mr Smith 594

Mr Jones 380

Jack 220

Mr Smith 250

Helen 77

Rebecca 580

Jack 500

..

..

..

So far so good.

But: Many names in column A appear more than once with different numbers inB. this is because the numbers were allocated over a longer period of time..

I want the numbers summed up for each person. In the example above the result should be only one row with Jack and the number 720. obviously this can be done with the SUM function but I dont want to go through the entire listand perform the same function every time again when a person appears more than once, especially since the list is ongoing.

Is there a way to automatically identify duplicates in column A and then sum up the corresponding numbers in column B?

Many thanks!