Hi

There is random list with countries (column B) and list/range of countries (column C). I would like C column to return count of each country in column B. but I don't want to use =COUNTIF(B2:B25,"Spain") and then same for each country. There must be a way to return count based on list/range in column C. Then to break the result by month (based on column A)

Tried to play around with Vlookup and Countif, Sumproduct, DCounta, but couldn't find the right solution. Must be simple but yet.... I attach the actual file. Thanks a lot for help
Country Count.xlsx