Countifs combined with multiple index/match

[MrVans1234]

I just can’t crack this one. Can anyone give a hint in the right direction, please?
I have this one sheet (Daily presens) where all of the leaders for each departement enters if the staff is pressent.
Then I have another sheet (qualifications) that contains all the certifications each worker has.
Now with +350 workers and +20 certifications to monitor, I’m looking for a way to get the number of the day in a New sheet (ressources).
I want it to lookup how many electricians is at work on the 5. of january.
I’ve tried to combine countifs with two index/matches, but I can only make it work with one specific WorkerID as the lookup.
Any suggestions?

 

[MrVans1234]

This is what I have:
=COUNTIFS(INDEX($B$10:$NC$371,MATCH($B$26,$B$10:$B371,0),59),INDEX(A25:AZ62,MATCH($B$26,B25:B62,0),5),”>0”)

B10:NC371 is the range of Daily presens
B26 is the workerID
A25:AZ62 is the range with the qualification
59 is the colomnnumber of today