For a given member in a given quarter you want separate total Hrs for each Eng?
Not easy using this path.
Are you sure it's not a pivot table you want?
See attached at cell G1, and another, slightly different arrangement at cell Q1. These take seconds to set up.
|