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
Bookmarks