SUMIF INDIRECT
=SUMPRODUCT(--(A2:A200="Apples"),--(C2:C200="Oranges"),D2:D200)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"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
|