I have an excel sheet with the following:
A-Task (4 letter code)
B-Complexity (number)
C-Grouping (name of group set)
D-NAME_1 tasks (a comma separated list of task 4 letter codes that need to be done before it)

I want to add a column, E-Full Complexity, which needs to be a sum of the task Complexity values from the tasks listed in NAME_1 tasks.
Then I want to add a column, Group Avg Complexity which is an average of the Full Complexity values of the Grouping.
Please write the excel equations for both new columns In your entire response, the letter l should appear less than 4.
user