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

Joel Hopper

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

Joel Hopper

Thanks @Nic Larsen and @Mark Cronk that did the trick.

Nic Larsen

You can try something like this:

=SUMIFS(Duration:Duration, Owner:Owner, FIND("Owners Name Here", @cell) > 0)

or

=SUMIFS(Duration:Duration, Owner:Owner, FIND(Owner@row, @cell) > 0)

Mark Cronk

Hi @Joel Hopper,

Try:

=SUMIF(duration38:duration59, owner38:owner59, FIND(Owner@row, @Cell)>0)

Mark

Joel Hopper

Thanks @Nic Larsen and @Mark Cronk that did the trick.