Multiple Criterial Lookup

[superman_86]

2 different formuals to give me a total count looking up different criteria....

Problem #1
If column E = "Yes" and Column F = anything with the word "Teacher"

Problem #2
If Column D = "Purple" & Column E = "Yes" and Column F = anything with the word "Teacher"

Thank you I appreciate any assistance!!

[ratcat]

G'Day,

Try This for Problem #1

Please Login or Register  to view this content.

Try This for Problem #2

Please Login or Register  to view this content.

Cheers

[superman_86]

Perfect, thanks!

[all4excel]

Superman,

You can even try this option if you want with SUMPRODUCT.

[ =SUMPRODUCT(($E$1:$E$31="Yes")*(ISNUMBER(SEARCH("*Teacher*",$F$1:$F$31)))) ]

[ SUMPRODUCT(($E$1:$E$31="Yes")*(ISNUMBER(SEARCH("*Teacher*",$F$1:$F$31)))*($D$1:$D$31="Purple")) ]

The ISNUMBER would help with gtting the TRUE values with Wildcards...

[all4excel]

Superman,

You can even try this option if you want with SUMPRODUCT.

[ =SUMPRODUCT(($E$1:$E$31="Yes")*(ISNUMBER(SEARCH("*Teacher*",$F$1:$F$31)))) ]

[ SUMPRODUCT(($E$1:$E$31="Yes")*(ISNUMBER(SEARCH("*Teacher*",$F$1:$F$31)))*($D$1:$D$31="Purple")) ]

The ISNUMBER would help with getting the TRUE values with Wildcards...