Princess V wrote...
. . . I used this formula - and yielded the same thing as I was
getting using a
different formula previously. But the value being returned by the
formula is not
consistent with what I get when I manually count the lines that
satisfy the
criteria specified. I now feel that there must be an issue with the
way the data
is set up in the worksheet.

Let me ask you - one of my columns is a list of departments that are
a
combination of numeric and letters. Example, 702R and 702HG. So when
I
specify within the formula - I am using:

=SUMPRODUCT((Matrix!$K$6:$K$1000&","&
Matrix!$P$6:$P$1000="spoc,started")
-(Matrix!$C$6:$C$1000&","&Matrix!$K$6:$K$1000&","&
Matrix!$P$6:$P$1000="702r,spoc,started"))
...

If the formula results in a smaller count than expected, then the
reason is almost always trailing spaces after entries in some of the
data ranges. You could check this by checking parts of the formulas.
Do

=COUNTIF(Matrix!$K$6:$K$1000,"spoc")

and

=COUNTIF(Matrix!$K$6:$K$1000,"spoc*")

give the same result? Ditto for col P and "started" and col C and
"702R". If any of these pairs of counts differ, you almost certainly
have trailing spaces you'l need to remove.


--
hgrove
------------------------------------------------------------------------
hgrove's Profile: http://www.excelforum.com/member.php...o&userid=11432
View this thread: http://www.excelforum.com/showthread...hreadid=274322