What function to use for 2 column with name and number for a total

What function and what formula would be used to add the total amount by each name - see below

Column A is the name Column B is the amount -

John 600
Bill 800
Andy 1000
Rich 200
Bill 533
Andy 755
John 654
Rich 654

Thanks for your help.

Try a Pivot Table or the SUMIF function

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Hi
the idea is to adapt the title of your original post. Only that title appears on the board
As for your post #3 a link was added to a site to show how it works

I have changed it in the first post. You can carry on now. Thanks!!

There is the pivot table that Pepe recommended.
Also the sumif function he also recommended.
to use a sumif you ought to create a distinct list of the names in col A in another location, I used cell D1 and down.
then the sumif pointed to D1 and columns A and B like so...
=SUMIF($A$1:$A$8,D1,$B$1:$B$8)