COUNTIF Formula

[francoiscj1]

This is my formula:
=If(Countif([Status],"Compliant")>0, CountA(Unique(Filter([Name],[Status]="Compliant"))),0)

I would like to modify this to include the following:

To count only if the retraining date is from 01/01/2024 to 12/31/2024 and if the frequency is "One Time" and if the training date is from 01/01/2024 to 12/31/2024.

Attached is a sample.

 

[hagia_sofia]

You probably forgot to attach the sample - could you please do it?

 

[francoiscj1]

Attached is my sample.