Sum some how!

I have three columns of information. In the first are account numbers, the second is an individual identifier and in the last the charge for each person


12345 James Jones $15
12345 Elaine Smith $12.50
23456 Will Johnson $15
23456 Andy Wilson $94.50

What I need to do is total the amounts for the account numbers so account number 12345 totals 27.50 for instance. In column A there is about 300 account numbers but 7000+ entries because there are many individuals on each account number, each on its own line, but not a specific number on each account. 12345 has 15 entries, but 23456 may have 90. Next week that could be switched or one of them may not be listed at all.

This report took the previous person about 4 hours to complete. I would like to write up a macro (most of it easy enough) so that I can do it in an hour Some things just can't be done with a macro, but no worries there!

Thanks for your help!!