Index and Multiple Match or ifCountIf formula

Good evening all. Let me see if I can explain what I am trying to do here. I am really not sure of even the best way to set this up. Here's what I have though.

A report of pass/fails from inspections on jobs over the course of 2021-2023 (It constantly expands)
What I have done so far is take that desired data from the report (sheet 1 "STP Measure Fail w Chris" and transfer totals onto the "All Offices" page using CountIf

PART 1:
This now reflects how many of each fail there are for each employee etc. Great, other than this is data from multiple years. So I broke them down into different sheets by office using:
=COUNTIFS('STP Measure Fail w Chris'!$I$14:$I$25999,"Bill-Fail", 'STP Measure Fail w Chris'!$G$14:$G$25999,"Raul Alvarez", 'STP Measure Fail w Chris'!$E$14:$E$25999, ">=1/1/2023")
Hoping it would now only reflect 2023 but it's showing 0 instead of counting just the 2023 fails.

PART 2.
For each of the fails (despite the type i.e. Bill Fail, CIP Corrected, Feasible Measure Fail, Hazard Fail, Measure-Fail I am trying to bring over the comments for each of them and I have zero clue on how to set this up. One beacuse I don't know if Index and Match can return strings of text or CountIf for that matter. I have tried a few things but I just get errors.
The Comments I am seeking out are on Sheet "STP Measure Fail w Chris" and they are in Column J "CIP Notes"

So the offices would then reflect there total fails for each associated fail column AS WELL AS with each fail the notes about them. I think part of what I struggle with is other than random dates there is nothing else to match them with since they are random. For Instance, emp a may have 4 bill fails and 1 hazard fail. How can I match multiple of the same thing with different notes...if that makes sense.

Thank you for the reply. I changed the date column as you stated, recopied the formula but now it gets an error. I checked my regional settings and it's on , seperated list. So I am not sure. Unless it's becuase of the date change.

COUNTIFS('STP Measure Fail w Chris'!$I$14:$I$25999,"Bill-Fail", 'STP Measure Fail w Chris'!$G$14:$G$25999,"Raul Alvarez",('STP Measure Fail w Chris'!$E$14:$E$25999, ">=1/1/2023"))

"There is a problem with this formula. Not typing the right formula.....etc

Ok not a problem. I did the ones you wrote above too and it's still given me the stiff arm haha. Here is a work book. Sorry it's taking so long to get back. I am traveling and it's not the easiest with out my home office tools. I did copy and paste your suggestions within this and same result: "0".

I should be able to work on that "part two" portion when I get home this weekend. I think I am going to create a drop down category that will reference these fails as "plumbing, electrical, etc. I don't really need the comments as much as I do a short answer of what was wrong. I can then find the comments. I think. This one has been rough to figure out in my head what makes sense and how to set it up. Unfortunately this is a report that is given to me and I can't change that format. But, without tons of manual effort I am essentially wanting to copy/paste this into a workbook and have it figure out the year to dates, the quantities for each person, and WHAT they are, with notes if possible.

That did work. I think what happend is I had two workbooks (an actual and a template) I made the change in one but not the other but had the formula in the opposite but not the other. I should have time later to work out part 1. That should be pretty straight forward. Thank you for the help once again, and I always love learing something new. That reference formula is wayyyy better.