More than 10% quicker

=SUMPRODUCT(--($A$1:$F$1="y"),--($A$2:$F$2="y"))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Rick Rothstein (MVP - VB)" wrote in
message ...
Give this a try...

=SUMPRODUCT(--(A1:F1&A2:F2="yy"))

Rick


"twototango" wrote in message
...
I have several sheets setup from which I need to caluculate: how many of
the
cells in a range meet both criteria. It's setup something like the
below:

A B C D E F....
1 y y n n y y
2 n y n y y n

I need to determine how many "y" in range A1:F1 that are also "y" in
A2:F2
across multiple sheets.

Thanks!