If Statement with Countif

[Crazyhorse]

A B C
1 Y Y
2 Y N
3 N
4 N Y
5 Y Y
6
7 Y Y

If there is a "Y" in Columns B and C then Count the "Y"

The Answer will be 3.

Thank you

 

[Elkar]

=SUMPRODUCT(--(B1:B7="Y"),--(C1:C7="Y"))

HTH,
Elkar

 

[daddylonglegs]

=sumproduct(--(b1:b10="Y"),--(c1:c10="Y"))

 

[Jim May]

Try:

=SUMPRODUCT(--(B1:B7="Y"),--(C1:C7="Y"))

JIm May