SUMPRODUCT & Wildcards

U

UWSPITHD

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.
 
B

Bernie Deitrick

=SUMPRODUCT(N(FIND(A11,$E$2:$E$3)>0),N($J$2:$J$3="Very Satisfied"))

HTH,
Bernie
MS Excel MVP
 
U

UWSPITHD

That did it thank you.
I did change "Aaron" back to A11 as the names contantly change. Thank you
again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Error When Sorting 1
Multiple Columns in Sum Range using SUMIFS 1
Find the next row... 0
SumProduct not right 7
Formula Help 2
Sumproduct gives #value 6
Sumproduct Help! 3
Filtering data 2

Top