Thread: sum of expenses and distributing them to appropriate columns

I will simplify my problem as much as i can...
I have 2 sheets...
The first contains columns (Salaries-Bonus-Tips)
The second contains a table that specifies expenses with a cell after each describing the type of expense (Salaries-Bonus-Tips)... Btw it is a dropdown list...

I want to see if i can let excel, AUTOMATICALLY, ADD up the expenses and organize the total and place them in the second sheet under the right column...

Example:

Tony: $100 : Salaries
Ricardo: $100 : Salaries
Bono: $20 : Bonus
Jenny : $10 : Tips
Mark : $ 5 : Tips

Excel would directly update the second sheet as follows:

Salaries - Bonus - Tips
$200 $20 $15

Please help as soon as you can because im overloaded with these silly annoying additions... Note that this is a simplified case and the actual problem has around 30 expenses and hence really troublesome!

here, look at the attachment

Book2.xls