How would I get total

I have an Excel spreadsheet where I store payments made. Column 1 is Customer name. Column 2 is amount paid. Each customer can make 50 - 100 payments a year and there are about 150 customers.

I would like to just have a seperate list of each customer and have a running total kept beside their name. As I enter a payment, it would automatically update the total beside the proper customer.

example:
Column 1 / Column 2
Joe smith / $50.00
John Doe / $100.00
Joe Smith / $25.00
John Doe / 300.00

How would I write a program where JOE SMITH would be updated to total $75.00 and John Doe $400.00 on a seperate list? I currently autofilter and write them all out.

Any suggestions?

Thanks.

 

forget it...SUMIF...found it.