| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wild characters in function?
=SUMPRODUCT((A6:A20007=A20012)*(B6:B20007=B20012)* (D6:D20007=D20012)*(F6:F20007)) This is a very nice way to do multiple sumif's to return a sum. Is there a way to use wild characters. For example one of the columns I am using is for departments. A certian goup starts with "42##" so in B20012 per the function above I put 42* in the cell but it did not work. Is there a way to do this. Thank you, Steven |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Eliminate wild characters | Excel Discussion (Misc queries) | |||
| Countif using Wild Card Characters | Excel Worksheet Functions | |||
| Wild Characters in "IF" function | Excel Discussion (Misc queries) | |||
| Using wild characters for an array | Excel Discussion (Misc queries) | |||
| Using wild card characters in array formulas | Excel Worksheet Functions | |||
Threaded Mode
