Count if text in adjacent cells in two columns match

[artz]

Hi,

Can someone in the Forum help with a cell formula that will count the occurrences of when the word "Yes" appears in adjacent cells in columns H and I?

Thanks,

Art

 

[FDibbins]

one way...
=countifs(H:H,"yes",I;I,"yes")

 

[artz]

Hi Ford,

Thanks, works perfectly. Just a note for others who might use this formula: there is a semicolon in the formula ",I;I,. This should be a comma.

Art

 

[FDibbins]

Hi Ford,

Thanks, works perfectly. Just a note for others who might use this formula: there is a semicolon in the formula ",I;I,. This should be a comma.

Art

ooops thanks for pointing that out.
correction
=countifs(H:H,"yes",I:I,"yes")

Im happy it worked for you