Using X-lookup within a Countifs function

I'm unsure if this is the right approach, but I want to be able to use a combination of countifs and xlookup, or vlookup, to check cells in column C to column G for employees that are working (indica...