=SUMPRODUCT(--(A2:A200="Apples"),--(C2:C200="Oranges"),D2:D200)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Alectrical" <Alectrical@discussions.microsoft.com> wrote in message
news:DDB54BE4-BC29-4A54-B990-29836E0FD0F3@microsoft.com...
> Hi
>
> Can anyone tell me how to sum a range of numbers in column D, provided
that
> adjacent cells in row A contain "Apples" and row C contain "Oranges".
>
> Thanks
> Alec