Tracking training Sessions and Leader training with Countif and if statements?

Hello

I am working on creating a complex spreadsheet that will track the active or inactive status of an individual who has received a certification to lead workshops and training classes. I have been working on this for a while, and have hit a wall and am reaching out for some friendly help.

I am attaching the spreadsheet that has been stripped of identifying data. It has two tabs. One that logs each training class or worksheet. It also records who facilitates the class/workshop and when it occurred.

The first tab list the name of the trainer and the rest of the information I need to make decisions. I started building the formula in column N, as a countif the trainer matches the trainer in the tracking spreadsheet, however this needs the second condition of "must only look at the last year". Column P will be the same with the change of past 2 years. (730 days). When I try to add the remaining condition, which I have written as

=COUNTIF('Track Workshop Training'!$A$3:$A$199,A3,'Track Workshop Training'!$B$3:$B$11>='Master Trainer'!F1)

I am getting the error that I have entered too many conditions for the argument. Can someone please help me fix my formula? or find a better formula to use?

Once that is completed, I will use the and/or formula to say the trainer is active if 1) they are in the first 12 months for workshops/18 months for training classes... Or they have held at least 1 workshop in the past 12 months or they have completed one training class in the past 2 years. Maybe there is a better way that the and/or formulas?

thank you

I added the CountifS() however It is not giving me a correct value. It is returning 0 and it should be returning a value of 1.

Perfect thank you very much!