Help with SUMPRODUCT
 

I don't know if this could be done, but if it's possible I would like
someone to tell me.

I have 3 columns
A............B..............C
Team1...AR..........Missing docs
Team2...JJ............CNH
Team1...JH...........CNR
Team1....AR..........POI missing

I want the sumproduct function to be able to count instances where A=
Team1, B= AR and C= missing; but the problem is that each cell in
column C is a comment, so there are multiple words (strings). i.e. C2=
"Missing" and "docs", C5= "POI" and "missing". How do I tell the
function to count only "missing"????

I have the easy part:

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

of course the last argument doesn't work.

Please help!

- Larry -
VBA Amateur :confused:


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

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