N
nrage21
I don't know if this could be done, but if it's possible I would lik
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 i
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 th
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
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 i
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 th
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