COUNTIFS that don't count the cell values but instead just count each cell as '1'

Hi All,

I am in desperate need of a formula which will count cells however exclude certain data and only count unique records (example spreadsheet attached).

I need the formula to exclude all 'XESF0001' and 'ZESF0001' information, and only count x1 line/entry for each unique person:

=COUNTIFS(Sheet2!L:L,"<>*ZESF0001*",Sheet2!Y:Y,"<>*XESF0001*")

In cells: B4, B7, B10, B15 and B16 there are aims which are not ZESF0001 or XESF0001. I need to forumal to count these (as 1 hit for each), however only x1 for each Person ID (A.

So for example: There are only x4 learners who are doing aims which are not ZESF0001 or XESF0001.

I appreciate any help with this.

Thanks,