Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT & Wildcards
I am using the forumla:
=SUMPRODUCT(N($E$2:$E$3=A11),N($J$2:$J$3="Very Satisfied")) to match names in a table with the overall satisfaction they recieve. The issue that I am running into is that some cells have more than one name in them. With the formula above A11 = "Aaron" in E2 there are 4 names one of which is Aaron. I need the formula to count his name even though it is not the only thing in the cell. I have tried... =SUMPRODUCT(N($E$2:$E$3=*A11*),N($J$2:$J$3="Very Satisfied")) but it does not work. Any suggestions would be great. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct and Wildcards | Excel Discussion (Misc queries) | |||
Sumproduct Wildcards | Excel Worksheet Functions | |||
Wildcards in SUMPRODUCT | Excel Worksheet Functions | |||
Sumproduct with wildcards | Excel Worksheet Functions | |||
Wildcards with SumProduct | Excel Worksheet Functions |