Count Matches from 2 Lists

Hi there,

I have 2 lists and I want to count the number of matches. This is not a match row to row, just generally. I also want to ignore blanks.

It seems like the formula I have is counting blanks too. I have tried =SUMPRODUCT(--(A2:A101=B2:B101))

The attached Excel sheet is an extraction of my main workbook, and I need the blanks included in the formula but not counted.

Can someone help with me a formula please

Thanks, Danny

Try it this way:

=SUMPRODUCT((ISNUMBER(MATCH(A2:A101,B2:B101,0)))*(A2:A101<>""))

Hope this helps.

Pete

Thank you Pete!

You're welcome - thanks for the rep.

Pete