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