software

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 quot;Yquot; in Columns B and C then Count the quot;Yquot;

The Answer will be 3.

Thank you

=SUMPRODUCT(--(B1:B7=quot;Yquot;),--(C1:C7=quot;Yquot;))

HTH,
Elkarquot;Crazyhorsequot; wrote:

gt; A B C
gt; 1 Y Y
gt; 2 Y N
gt; 3 N
gt; 4 N Y
gt; 5 Y Y
gt; 6
gt; 7 Y Y
gt;
gt; If there is a quot;Yquot; in Columns B and C then Count the quot;Yquot;
gt;
gt; The Answer will be 3.
gt;
gt; Thank you


=sumproduct(--(b1:b10=quot;Yquot;),--(c1:c10=quot;Yquot;))--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=531650Try:

=SUMPRODUCT(--(B1:B7=quot;Yquot;),--(C1:C7=quot;Yquot;))

JIm May

quot;Crazyhorsequot; wrote:

gt; A B C
gt; 1 Y Y
gt; 2 Y N
gt; 3 N
gt; 4 N Y
gt; 5 Y Y
gt; 6
gt; 7 Y Y
gt;
gt; If there is a quot;Yquot; in Columns B and C then Count the quot;Yquot;
gt;
gt; The Answer will be 3.
gt;
gt; Thank you