XLOOKUP and COUNTIFS?

First off, I apologize if this is posted in the wrong place. I am new to the forum and this is my first post. I have a Timesheet workbook (attached) that not only needs to count the hours worked by day and employee, but also any time off by day and employee. This is complicated because my boss wants the time off return type to be listed (.i.e. EAB, instead of hours given off). I was able to craft an XLOOKUP formula to return the amount of normal hours worked, and in a separate cell (F4) craft a formula that will return the text if it's greater than 0, but I am having no luck putting it altogether. I need it to look in 'Timesheets' columns N-Q and return the text listed in the heading if greater than 0, in addition to the normal hours worked ('Timesheets' column Z). The end result will either be normal hours worked or one of the four time off headings in the time sheet. Any help or insight would be greatly appreciated.

Without using the helper sheet, try this in C4:

Please Login or Register  to view this content.

Then copy the formula across to I4 then C4:I4 formula copied down the table as necessary.

WBD