| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a wild card in SUMPRODUCT
I'm using the following formula:
=SUMPRODUCT(--(D6:D1000="*/2-2 IN"),--(E6:E1000'="NBI")) which returns a value of "0". The "*" could be an A, B, C, D, HHC, or E. If I replace the * with one of the letters, I get a correct value. How can I use the wildcard returning a correct value for all the true conditions of A/2-2, B/2-2, C/2-2, D/2-2, E/2-2, and HHC/2-2? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I use wild card in SUMPRODUCT formula? | Excel Worksheet Functions | |||
| wild card in sumproduct | Excel Worksheet Functions | |||
| sumproduct with a search and wild card | Excel Discussion (Misc queries) | |||
| Wild Card Search | Excel Worksheet Functions | |||
| Wild card * | Excel Worksheet Functions | |||
Threaded Mode
