I'm banging my head against a wall here. Can anyone help? Bascially, I've got a structured table where the last x# columns are week ending dates for staff and the user will fill out hours in each column for each staff member. However, the trick is that each staff member may be on multiple rows (each row represents a staff member on a project). I want to be able to use conditional formatting to tell me if that person (rows) have achieved 40 hours per column. Here's the formula I came up with, understanding that conditional formatting won't straight up accept structured references, so apologies for all the **** INDIRECTs.
Let me know if you need me to attach an example.
Code:
=SUMIF(INDIRECT("table_Area1[Full Name]"),INDIRECT("[@[Full Name]]"),INDIRECT(INDEX(INDIRECT("table_Area1"),,MATCH(F$1,INDIRECT("table_Area1[#Headers]"),0))))=40
Let me know if you need me to attach an example.