On Wed, 18 Jul 2007 17:21:07 -0400, "T. Valko" wrote:

Note that TRANSPOSE is an array function and requires array entry. So in
using this you may as well use the SUM version rather than the SUMPRODUCT
version since *both* require array entry.

=SUM(--(MMULT(--(A1:D4="yes"),TRANSPOSE(COLUMN(A1:D4)^0))=n))

I used the SUM function in my example.
--ron