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
--
nrage21
------------------------------------------------------------------------
nrage21's Profile:
http://www.excelforum.com/member.php...fo&userid=4808
View this thread:
http://www.excelforum.com/showthread...hreadid=319718