How to calculate the total number of days of each team member involved in a task.

Gilbert P

Each cell may have more than one name listed as a multicontact.

Gilbert P

The task is planned on a sheet with names assigned to it. There may be multiple names, as in a multicontact cell assigned to the task. Another sheet is created to calculate the total number of days each team member has worked on the task. Unfortunately, only the total number of days for the first name in the list is calculated, whereas it returns a 0 for the other contacts in the multicontact cell.

Paul Newcome

Are you able to provide some screenshots for context?