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

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!