Hi

I guess there there would no "Hong Kong" or "Kotka" in the range.

Declare two variables and do a countif for those 2 criterias like I did for date.