How do I sum a range for a contact when the contact is in a column that allows multiple contacts?

I tried =SUMIF(Owner38:Owner59, Owner@row, Duration38:Duration59) but this only works if the Owner is the only name selected in the cell. If the Owner is included with another name in the cell it doesn't find the owner.

Formula returns 2 instead of 12

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!