I have a formula that I can't get quite right, and I'm hoping to get insight on. I'm pulling information for one week at a time, and using the xlookup function for the formula but need to auto calculate the sum of Actual Hours per day. I think I have most of the formula correct, except I can't quite figure out where the sum formula would go into place for Column F.

Here is the formula I have:
=XLOOKUP($I7,$A:$A,$F:$F,MATCH($L$1,$G:$G,0)*MATCH(J7,$C:$C))

I'm at a total loss, so any suggestions would be Amazing!

Employee Doc PR.pdf