I have two tables as attached, I would like to know what concept to use like lookups/ index-matching/… to match and sum the value in the 2nd table. Kindly direct me towards the right approach.

I have this table of what people are missing on each month, and what are they missing(maked as missing) or they have(marked with an “X”) or if the guy wasn’t working at that time, it says not working.

I have this table of what people are missing on each month, and what are they missing(maked as missing) or they have(marked with an “X”) or if the guy wasn’t working at that time, it says not working.

I have used this function to get how many times a specific input occurred in 3 shifts “M, E and N”

Please help with the formula with the following conditions: