Count if two column ranges contain same value

[android1]

Hi,

Need to count 1 every time a cell in range 'CHO1'!E2:E1000 contain the letter Y And the corresponding cell in range 'CHO1'!H2:H1000 contain the letter Y.

=IF(AND('CHO1'!E2:E1000="Y",'CHO1'!H2:H1000 ="Y"),1,0) does not return anything.

I would expect to return 2 for below.

 

[Joe4]

Use COUNTIFS.
See: MS Excel: How to use the COUNTIF Function (WS)

 

[android1]

Use COUNTIFS.
See: MS Excel: How to use the COUNTIF Function (WS)

Thks.
Works with - =COUNTIFS('CHO1'!E2:E1000,"Y", 'CHO1'!H2:H1000,"Y")

 

[Joe4]

You are welcome!
Glad I was able to help.