sumif / sumproduct for number of coincidences

[Mika]

Hi all,

I have two list of numbers (say colums A and B) that change values for
different settings.

I need to have a formula that counts the number of coincidences in
colum B. Coincidences mean that the value in a B cell, cell b10 for
example, has the same value that the matching cell in A (cell A10 in
this case). Other example below. In that case the number of
coincidences is 1.

A B

3 2
5 5
1 7
7 1

Thanks for your time
Mika

 

[Roger Govier]

Hi Mika

Try
=SUMPRODUCT(--(A1:A4=B1:B4))

 

[Mika]

Roger, you did it !!

Thanks
Mika

Roger