Excel Drop Down / Formula Help

Hey Everyone,

I am looking for some help with this formula.

I have a spread sheet that has 11 categories, all are sorted into a dropdown menu in Column 'D'. In Column 'C' I have numbers which are associated with those 11 categories. My objective is to be able to enter my numbers in 'C', select which category in 'D', and all of the matching numbers associated with a specific category is added up and given to me in a seperate column.

For example:

I have three entries into cat.1 (50, 25, and 10), and two entries into cat.3 (10 and 5).

In Column 'F' it tells me the added total of all cat.1 (85)
In Column 'G' it tells me the added total of all cat.2 (0)
In Column 'H' it tells me the added total of all cat.3 (15)... etc.

Is this possible with a formula, or do I need to enter a code into Visual Basic?
Any help would be greatly appriciated.