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

HTH,
Elkar


"Crazyhorse" wrote:

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