sumif / sumproduct for number of coincidences
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
|