Thread: compare rows for a match and sum the matches
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
  
Posts: 1,240
Default compare rows for a match and sum the matches
Bert wrote:
How do I compare numbers say d101:l101 with c17:k17 and count the number of
matches between the 2 ranges?


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

=SUM(--(C17:K17=TRANSPOSE(D101:L101)))
Reply With QuoteReply With Quote