This should be an easy one, but nothing is coming to me! I have an expense
sheet where the user will list account codes and the amount spent for that
code. They can enter the same account code numerous times. I then have a
summary box that I want to auto populate the account codes used and the total
dollar amount spent for that code:

A B C
06000 50400 $15
06000 50200 $50
06000 50400 $26
06100 50200 $100

I would like the summary box to show the following:

J K L
06000 50400 $41
06000 50200 $50
06100 50200 $100

I cannot figure out the formula that will combine the duplicates and then
total the amount.