I have my Data tab, where column F is a city (ex: London, Paris, etc).
I have a separate "Regions" table that has a list of cities in column A, and the corresponding country in column B.
I am looking for a formula that will count the number of rows in Tab1, where city in column C matches country "UK" in the table in Tab2.
I ended up with a countif that looks like this.. but realizing I'm asking to match "London" with "UK".. so result is zero.
=COUNTIFS(Data!F:F,VLOOKUP(Data!F:F,Regions[#All],2,False))
I am trying to get a formula that will give me the correct count directly, where I wouldn't need to add a column to my Data to populate the correct country for each row with a vlookup... then have a simple countif.
I actually have a 2nd condition, same situation (sites, with a table that associates sites to a company)... but once I have the logic down for one, countifs would allow to have both.
Or maybe I have to take another approach entirely.. looking for some guidance.
Thanks !
I have a separate "Regions" table that has a list of cities in column A, and the corresponding country in column B.
I am looking for a formula that will count the number of rows in Tab1, where city in column C matches country "UK" in the table in Tab2.
I ended up with a countif that looks like this.. but realizing I'm asking to match "London" with "UK".. so result is zero.
=COUNTIFS(Data!F:F,VLOOKUP(Data!F:F,Regions[#All],2,False))
I am trying to get a formula that will give me the correct count directly, where I wouldn't need to add a column to my Data to populate the correct country for each row with a vlookup... then have a simple countif.
I actually have a 2nd condition, same situation (sites, with a table that associates sites to a company)... but once I have the logic down for one, countifs would allow to have both.
Or maybe I have to take another approach entirely.. looking for some guidance.
Thanks !