Hi

You must have a text value in your H range.

Andy.

"Alectrical" wrote in message
...
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")*(H 13: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" wrote in message
...
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