I am trying to setup an automated metrics sheet from many other sheets and I am stuck on the very first "reference another sheet" formula due to the conditions (countifs) that I'm trying to get it to pick up. Here's the example:
The metric sheet is trying to count KPI's from other sheets, for this particular instance a hazard count. I have another sheet where information is gathered called "Hazard Report Register" 2 of the columns in the sheet will effect the countifs they are; "Date" and "Person Raising Hazard"
What I ultimately want it to do is; in a cell tell me how many times a particular individual has raised a hazard in that month, but I believe the "Date" part is messing with my formula.
(Note the "Hazard Report Register" has hazards entered from other years then the current e.g. January 2022 that I don't want it to count).
The below is a screenshot of a section of the metrics sheet,
John Smiths Jan 2023 tally should be at 2.
Any help on the required Formula would be appreciated, I will then have to duplicate it for all my other sheets and KPIs.