| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wild card in two condition text formula
=sumproduct(--(A1:A400<""),--isnumber(search("A.A.A",D1:D400)))
=search() doesn't care about upper/lower case =find() is case sensitive jmrd wrote: I am using the following formula to count text that have two conditions 1) Column A is not blank 2) Column D contains a particular word =sumproduct(--(A1:A400<""),--(D1:D400="*A.A.A.*")). I am getting a value error. Column D may or may not contain text that has A.A.A. in it somewhere. Any thoughts? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Being treated as Text | Excel Worksheet Functions | |||
| Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Using the text from a cell as a range name in a formula | Excel Discussion (Misc queries) | |||
Linear Mode
