compare rows for a match and sum the matches

B

Bert

How do I compare numbers say d101:l101 with c17:k17 and count the number of
matches between the 2 ranges?
 
G

Glenn

Bert said:
How do I compare numbers say d101:l101 with c17:k17 and count the number of
matches between the 2 ranges?
Click to expand...


Array-formula (commit with CTRL+SHIFT+ENTER):

=SUM(--(C17:K17=TRANSPOSE(D101:L101)))
 
Top