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!