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
-
Thanks @Nic Larsen and @Mark Cronk that did the trick.
Answers
-
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)
-
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Thanks @Nic Larsen and @Mark Cronk that did the trick.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!