Text wild card search

[Guest]

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

 

[Biff]

Add this array to your formula:

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

Biff