Need Help to Auto Sum based on Data Validation Drop Down menu

[AndreaSSVA]

Windows 7/MS Excel 10

I have created a monthly expense sheet with a drop down data validation in column A that states the expense type. I then have the amount of that expense in column D. I need to be able to perform an auto sum function that adds the amount based on they type of expense picked from the drop down.

I really don't even know if this is possible, but I figured I would check to see if anyone could help.

For example.

Expense	Amount		Total's
(dropdown)Food	$5		Fuel	=All Fuel
(dropdown)Fuel	$100		Food	=All Food
(dropdown)Misc Exp	$17		Misc Exp	=All Misc Exp
(dropdown)Food	$32

<tbody>
</tbody>

Thanks in advance!

 

[Brian from Maui]

Have a look at SUMIF

 

[AndreaSSVA]

Oh my gosh! That was it. Thank you!!!! Don't know how I missed that one .