Hello...A long time lurker, I can't tell you how many times I've had a problem solved by searching through here. I've found simular questions, but I can't make a solution work.

What I am trying to do is add up all of the sales for each customer in a spread sheet.

Sales Order# Customer $
1 CustomerA $100
2 CustomerB $10
3 CustomerA $50
4 CustomerA $75
5 CustomerC $30

What I would like it to consolidate each customer and show me:
CustomerA $225
CustomerB $10
CustomerC $30

This is a large spread sheet with 1000's of customers and about 50,000 transactions.

Thanks for your help!

Eric