Thanks Andy, your function works on a new sheet, but when I type the
following function into an existing sheet I get the #VALUE message. Any ideas.

=SUMPRODUCT((A13:A6000="IO")*(F13:F6000="2PLC")*(H13:H6000))

"Andy" wrote:

> 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
>
>
>