Formula Help!

[Bahama85]

Me again :)

Need help creating a formula to extract from Column J or at least J2:J4500 based off of the criteria from the Employee Name in AA10, Date in N6 and the 1st Floor Mezz in AB8 and the information from the green table. Very new to formulas and still haven't grasped which type to use for what type of info to pull. Thank you in advance! 

https://1drv.ms/x/s!Agmju254hK9cgjomY2ySsoghIfuS   

 

[#2]

You have "Aguilar, Hector" 4 times in date 9/12/2022. What result do you expect for this person?

[#3]

So the Account Name (column K) is each pick zone that each employee picked out of on that date. Aguilar, Hector tasked into 4 separate areas but he does not have a task for 1st Floor Mezz so his hours would reflect a "0".

However, if you look at Avila, Efrain - he has 4.95 hours into 1st Floor Mezz. Cell AC11 needs to show 4.95