Count dublicates

[Bogi]

I have three colums with data. I would like to count dublicates that are in
all colums.
Can somone help
Thanks

 

[Bogi]

Thanks a lot

 

[Bogi]

Thanks a lot

Hi,
try

=SUMPRODUCT(--(ISNUMBER(MATCH(A1:A100,B1:B100,0))))

change range to fit your needs