Formula to SUM for a Given Field Type Specified in another Column

Hi All,

I'm sure this will be a very simple one for someone - it leaves me *head scratching* though!
I have attached a VERY generic example and it includes what I am trying to SUM for the given data.
From the example if we look at Question Z1:
"Total Cost of All types of "Lemons" " = ??
I could simply do

=SUM(C2:C9)

, however this is a very simplistic spreadsheet for me to learn the formulae to apply to my spreadsheet that is MUCH bigger.

I require the formula to:
Sum the costs of all the Types of the Fruit, when the fruit is specified by "H4". I.e. if Column A if = to "Lemons" as specified by "H4", SUM the Relevant section of Column D.

To move on further, e.g Question Z4, Sum the cost of all the Fruits as specified by "H4" that their 'Use' is equal to "I4", i.e. 'Lemons' to 'Eat'.

I guess the above may require some IF statements and or VLOOKUP, I'm just not at all sure how to setup the formula to get the required outcome. Any help would be appreciated - Sorry for the long winded explanation!

Cheers,
Mark