Sumif

I am trying to retrieve some information from a sheet.

column d row 6 to 46 has a text value (Type) eg apples, peaches, nectarines.
column e row 6 to 46 has the number of apples, peaches, nectarines.

I want to make a formula that will search column d row 6 to 46 for apples then go to column e row 6 to 46 and add all the number of apples in these rows to give me a total for the number of apples from row 6 to 46 column e.

I then want to repeat the formula for peaches and nectarines.

Any help with this would be greatly appreciated.

Thanks Chris

Awesome so simple but effective, works a treat!
Thanks very much.
Chris

Need your help again<

can the formula also include another apple column and no of apples column
eg x6:57 Apples & z6:57.

Cheers Chris

Hi Again
I need help again with this SUMIF formula if possible.
I would like the formula to add another set of data to it.
Tried this but doesnt work

=SUMIF((D6:D46,"Apples",E6:E46) + (X6:X57,"Apples",Z6:Z57))

Any help would be greatly appreciated

Cheers Chris

Hi again
Sorry I posted another reply before reading your answer.
Again it works well your help is much appreciated.

Cheers Chris