| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy from a Cell to a text box. | Excel Worksheet Functions | |||
| Text Search in an Array | Excel Discussion (Misc queries) | |||
| Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
| How do I search for specific text and sum the cell to the right? | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
Threaded Mode
