Not working {={sum(if(A1:B3=C1:D3,1,0))} sometimes

  • Thread starter Thread starter dindigul
  • Start date Start date
D

dindigul

I have values 11,12,13,14,15,16 in A1:B3 and in C1:D3 I have 1,2,14,3,4,5.
That is, instead of matching 14 in A2 with C2, I put it in D2. Now if I use
the above formula, I get a zero, also when I check for <> I get 6.. However,
If I put it back to C2 I get 1 & <>=5. Why this irregularity?
 
No need for transpose or array entering, this should work

=SUMPRODUCT(COUNTIF(A1:B3,C1:D3))
 
Back
Top