ExcelBanter - If Statement with Countif

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If Statement with Countif (https://www.excelbanter.com/excel-discussion-misc-queries/82522-if-statement-countif.html)

Crazyhorse

If Statement with Countif

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

If Statement with Countif

=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

daddylonglegs

If Statement with Countif

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

--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=531650

Jim May

If Statement with Countif

Try:

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

JIm May

"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

All times are GMT +1. The time now is 09:45 PM.