=SUM(--(MMULT(--(A1:C3="No"),--(ROW(A1:A3)0))0))

That's kind of misleading. Specifically, the use of --(ROW(A1:A3)0). That
would imply that array2 is based on the number of rows in the range.

Array2 needs to be a vertical array based on the number of *columns* in the
range. The posted sample data just happens to have 3 columns and 3 rows of
data so as written that formula will work.

However, if the range was A1:C4 (still 3 columns) and you
used --(ROW(A1:A4)0), then the formula would fail.

--
Biff
Microsoft Excel MVP


"Luke M" wrote in message
...
Possible solution:

=SUM(--(MMULT(--(A1:C3="No"),--(ROW(A1:A3)0))0))

Multiples the rectangular true/false array by a single column of 1's (the
ROW function generates this).

--
Best Regards,

Luke M
"cooey" wrote in message
...
Hi.

Sample data:
R1: No, Yes, No
R2: Yes, Yes, Yes
R3: No, No, No

How do get a count of the rows that contain No?

So for the sample above, the output i'm looking for is 2 (2 rows
where No exists).

TIA!