SUMPRODUCT with condition FIND(text) is false
Go Bucks!!! wrote:
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,
The syntax for FIND is as follows:
FIND(find_text,within_text,start_num)
I would use this in your SUMPRODUCT():
ISERROR(FIND("Dedicated",C:C))
|