View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Go Bucks!!![_2_] Go Bucks!!![_2_] is offline
external usenet poster
 
Posts: 28
Default SUMPRODUCT with condition FIND(text) is false

Using Excel 2007

I want to do a sumproduct where one of the conditions is that "Dedicated" is
NOT present in C:C. Dedicated can appear anywhere in the text and the text
varies, so I am using a FIND.

I am not sure how to do this? Here was my quess...

=SUMPRODUCT((A:A="GOLDMAN")*(B:B=1)*(FIND(C:C<"De dicated)))

Thanks,