SUMIF formula when cell contains multiple collaborators
I currently have a formula that will sum up the "Hours Used" from the "proposed hours needed" field based on which intern is assigned.
=SUMIF(Intern:Intern, "Michelle", [Proposed Hours Needed]:[Proposed Hours Needed])
However, when BOTH interns are assigned, it doesn't acknowledge the hours - how can I update my formula to include that if both interns are chosen to divide the Proposed hours in half and add the halves independently to each interns Hours Used? - so in the example, I'd want 10 hours to show up for each intern in their Hours Used
Help Article Resources
Check out the Formula Handbook template!