I have a spreadsheet where I have multiple sheets for different locations and in each location sheet I have names and months. (column B is the name and column C shows different months)
On the main sheet I want to create a list of how many times a name appears against each month, so for example how many times does the name Ben appear against October.
Can this be done using formulas? or would it be a pivot table?