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!