Excel question

[superboy]

I have a list of repeating names in column A and in column b, I have a sales amount. In column C or D, I want to be able to write a function that sums up the total sales by name that each account made. Essentially I want to be able to write one of the 4 names below in column A along with an amount in sales and have column C or D automatically update the total sales by name. Please help me.

Names	Sales	Tota by name
John	$10	John
Corey	$35	Corey
Dave	$4	Dave
Dave	$50	Smith
Smith	$13
John	$55
John	$66

<tbody>
</tbody>

 

[grizz]

c2 is the name you want (john) then in d2 =SUMIF($A$2:$A$8,C2,$B$2:$B$8)