Thread: SUMIF INDIRECT
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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