Hi Excel gurus,

I have 3 columns:

A B C
1 Hi Hi
1 Med Lo
1 Hi Lo
2 Lo Lo
2 Hi Hi
2 Hi Med
3 Med Med
3 Hi Lo
3 Lo Lo
3 Med Hi
4
4


As time goes by the three columns grow (up to 195 rows).
I have written the following function to count the number of matches:

{=SUM(IF(ISTEXT($C1:$C195),IF(B1:B195=$C4:$C195,1,0),0))}

This returns "5" because 5 of the 10 rows so far have matches.

Firstly, there's got to be a simpler way to do this.

Secondly, I'd like to write a match function that will provide the following output based on the Round provided on the cell to the left:
Round Matches
1 1
2 2
3 2
4 0

Thanks in advance,
Jeff Popova-Clark
Australia