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,

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))

SUMPRODUCT with condition FIND(text) is false
 

Using Excel 2007

Maybe this:

=COUNTIFS(A:A,"goldman",B:B,1,C:C,"<*dedicated*")

Note that an empty cell in column C will not contain dedicated so it could
be counted if the corresponding cells in columns A and B meet their
criteria.

--
Biff
Microsoft Excel MVP


"Go Bucks!!!" wrote in message
...
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,