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:


Sheet name"Candace" Sheet name "Sylvia" Sheet name "Wendy"

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


I need to determine the number of "y" in range A1:F1 that are also "y" in
A2:F2
in sheets "Candace", "Sylvia", and "Wendy".

Thanks!