Hi

Try something like this:

=SUMPRODUCT((A2:A1000="Apples")*(C2:C1000="Oranges")*(D2:D1000))

When using Sumproduct, make sure that the ranges are all the same size and
are not full columns.

Hope this helps.
Andy.

"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