Looking to do a COUNTIF formula but paste it whilst using concatenation to change the criteria each time e.g
In column B I have a list of place names and in column C I would like it to show the number of times that place name is present in Column Q.
Would need to be setting the value of each...