Re: Text wild card search

Add this array to your formula:

(ISNUMBER(SEARCH("pricing",OFFSET(Chk_COG_Build!$A$1,4,,CountA!$B$2,1))))

Biff

"Chad" <Chad@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:636E0B74-5731-4784-8B75-F43DB922FC17@xxxxxxxxxxxxxxxx
Below is a sumproduct formula that works great:

=SUMPRODUCT((OFFSET(Chk_COG_Build!$A$1,4,1,CountA!$B$2,1)="Dessert")*(OFFSET(Chk_COG_Build!$A$1,4,2,CountA!$B$2,1)<=AH$4)*(OFFSET(Chk_COG_Build!$A$1,4,3,CountA!$B$2,1)>=AH$4))

I would like to add one more set of criteria into this formula but I am
not
sure as to how. I would like to add something like :

OFFSET(Chk_COG_Build!$A$1,4,,CountA!$B$2,1)="Pricing")

But I would like the formula to look for "pricing" ANYWHERE within the
cell
it is referencing and I am not sure as to how to go about this. Can
anyone
please help me out?

Thanks,
Chad






.

Loading