Text wild card search
 

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)="Prici ng")

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

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" wrote in message
...
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)="Prici ng")

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