Following problem:

x 4 4
x 1 2
y 4 3
y 3 2
z 3 3

I am trying to count the number of times a value in column 2 matches the value in column 3, given a value in column 1. I.e. if column1=x, the result should be 1. if column1=y, the result should be 0, etc.

Could you please help solve this problem? I have to apply it to a spreadsheet with thousands of entries..

Thanks!