Duplicate account codes that total amount
Have a look at Pivot Tables. Worth while learning because if you can come to
grips with them, you will find numerous uses for them in the future.
--
Regards,
OssieMac
"MMM" wrote:
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.
|