Counting Text in one column that matches another column

Hello,

I was trying to accomplish the following task and could use some support with the formula for it in Excel. As you can see below, I need to count the cities that appear in column A that match column B as a total number. I will have other words in column A that I do not want counted. I have been trying to use the CountIFS and SUMIF Functions and haven't had any success.

Column A
Las Vegas
San Diego
Las Vegas
Orlando
Phoenix
Phoenix
Florida

Column B
Las Vegas
San Diego
Orlando
Phoenix

Total = 6



I would really appreciate the help!

Thank you

You can use this array* formula:

=SUM(COUNTIF(A1:A7,B1:B4))

adjust the ranges to suit.

*An array formula must be confirmed using the key combination of Ctrl-Shift-Enter (CSE) rather than the usual <Enter>

Hope this helps.

Pete

HI Pete,

Thanks so much for the advice. This works great. I came across this type of formula before and couldn't get it to work right. But, you helped. Thanks again!