count number of cell have the same value

Hi

I have two column
A B
-----------
1 2
2 2
3 1
4 3
5 4

I want to count the number of cell in column A that have the same value of cell at the same row of column B
In this example it should return 1 as A2=B2

Can you please show me how to do it plz?

Thanks you very much

Originally Posted by duongthaiha

hi

i have two column
a b
-----------
1 2
2 2
3 1
4 3
5 4

i want to count the number of cell in column a that have the same value of cell at the same row of column b
in this example it should return 1 as a2=b2

can you please show me how to do it plz?

Thanks you very much

=sumproduct(--(a1:a5=b1:b5))