counting matches

I am looking to count the amount of matches between to columns

here's my example (my data is obviously a bit bigger, but there are no duplicates in each column)

Column A Column B
beer tea
coffee wine
milk sprite
tea juice
coke milk
gin water


So I would want a total number of matches between two columns, which should equal 2.

Anyone got any help they can give?

thanks again to the forum.

Try this:

=SUMPRODUCT(COUNTIF(A1:A100,B1:B100))

Ola Sandström