=COUNT(IF((A2:A5="High")*(B2:B5="High"),1))

Array formula you have to commit CtrlShiftEnter (not just enter)



"smaruzzi" wrote:

I have to arrays of test strings. Values could be Low, medium or High in both
arrays. I need to count how many pairs of High values appear when only High
has been selected for any row. In other words, when the same label has been
assigned in both column, that's a valid instance I wanna count.

here's an example:

Array1
Low
Medium
High
High

Array2
High
Medium
High
Medium

There is just one pair of Highs (3rd), and therefore the returned value
should be 1.

Thanks, Stefano