Excel conditional counting

Question

This is a doubt that arose in my workplace, and it should be pretty straightforward.

We have two columns of numbers, say:

1 1
1 2
2 1
2 2

And we want to get the number of rows that have equal numbers (2), without a helping column for each comparison. We can't get a working matrix operation (wich is the way we think correct). Any ideas?

Thanks in advance!

Answer 1

We got it.

{=SUM(IF(A1:A10=B1:B10;1;0))}

Thanks anyway!