Key matches in both tables

[chriys1337]

Hello,

I try to find out, how often my key matches in both tables.

Please see attached sample file.

Is there a possibility to work with the where exists function? And / or do you have other ideas how to solve this question?

Thanks!

[YoussefBelloum]

Hi,

try this:

=sum(if( (len(Trim(C))=0 and len(trim(D))=0) or (len(Trim(A))=0 and len(trim(B))=0), 0, 1))