Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sumproduct with Wildcard *
I would like to use a wildcard character with a sumproduct formula.
Data 1 A B C 2 Joe CA 01 3 Sue MA 01 4 Dan CA 02 6 * CA 01 =Sumproduct((A2:A4=A6)*(B2:B4=B6)*(C2:C4=C6)) With "*" in cell A6 I expect to get a result of 1 but instead I get 0. Any suggestions? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |