Matching multiple values from 1 worksheet to another worksheet

[jamesjessie117]

Matching multiple values from 1 worksheet to another worksheet and counting it. This formulae {=IF(COUNTIF(S!$D$1:$D$50000,B5)=0,"NS",SUM((S!$D$2:$D$50000=Score!$B5)*(S!$D$2:$D$50000="10-- Extremely likely"),(S!$E$2:$E$50000=Score!$E5)*(S!$A$2:$A$50000=Score!$C3),(S!$D$2:$D$50000=Score!$E5)*(S!$D$2:$D$50000=9),(S!$E$2:$E$50000=Score!$E5)*(S!$A$2:$A$50000=Score!$C3)))} is killing my head..........................

[jamesjessie117]

Having hard time to solved this one.

[jamesjessie117]

Matching multiple values from 1 worksheet to another worksheet and counting it. This formulae {=IF(COUNTIF(S!$D$1:$D$50000,B5)=0,"NS",SUM((S!$D$2:$D$50000=Score!$B5)*(S!$D$2:$D$50000="10-- Extremely likely"),(S!$E$2:$E$50000=Score!$E5)*(S!$A$2:$A$50000=Score!$C3),(S!$D$2:$D$50000=Score!$E5)*(S!$D$2:$D$50000=9),(S!$E$2:$E$50000=Score!$E5)*(S!$A$2:$A$50000=Score!$C3)))} is killing my head..........................

[dredwolf]

-Edit-
I must be going blind, just saw the sample..sorry

[dredwolf]

The closest I've come is the following

Please Login or Register  to view this content.

however i can't get the date match to return anything but False..so I'm obviously doing something wrong on the first comparison ..will keep trying for you though

-Edit-
Found the problem, 'S' sheet is using full date/time code,while score is only using date code..

[dredwolf]

Revised Formula:

Please Login or Register  to view this content.

Hope this helps

-Edit-
Revision in RED to force a String check

-Edit 2-
Here's a wb showing this formula expanded to the 3 columns of the first test (01/11/2012)

[jamesjessie117]

Thank you much!!!

[dredwolf]

You are welcome