View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mika Mika is offline
external usenet poster
 
Posts: 48
Default 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