Running total based on groups in MS Excel 2007

[ComputerNewB]

Hello everyone,

I'm doing a spread sheet to track my spending and i would like to know if there is a way i can keep a running total based on the type of expense. 

For example:
There are 4 types of expenses, Food, Bills, Ent, Others.  The totals of these expense are held in cell D3, D4, D5, D6 respectively.

Column C has a drop down of the four expenses and Column B have the amount spent.

If i put $30 in B3 and select Food in C3, i would like D3 to automaticly update itself by an additional $30.  If i put $34 in B4 and select Others in C4, I would like D6 to update itself by an additional $34.... etc....

Does anyone know how to make this work?  Thanks in advance for any suggestion.

[ComputerNewB]

Just got the answer from another source if anyone else is interested in doing this.

One way is to use the Sumif statement. 
For example
SUMIF($C$3:$D$2001,D3,$B$3:$B$2001)

Sum the amount of a cell in column B if a cell in column C matches cell D3 (Food).  You would type the formula in cell E3, and the word Food in cell D3.