Nevermind. I found the solution.

=SUMPRODUCT(($A$2:$A$100="Team1")*($B$2:$B$100="AR ")*((ISNUMBER(SEARCH("missing",$C$2:$C$100)))) )

:)


--
nrage21
------------------------------------------------------------------------
nrage21's Profile: http://www.excelforum.com/member.php...fo&userid=4808
View this thread: http://www.excelforum.com/showthread...hreadid=319718