Sumif

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