SumIf question

Hey folks. I'm trying to sum the contents of the column (JobSite Hours) if a certain contact is selected on an adjacent column (Special Conditions). The special conditions column is in fact set up as a contact. my formula works if only one contact is chosen, but the special conditions column is a multi select cell. If there are more than one contact selected, my formula won't work correctly. Any help?

=SUMIFS({FW-MWS Jobsite Hrs}, {FW-MWS Special}, [Sigma Design]$5)

FW-MWS Jobsite Hrs is the column on another sheet for JobSite Hours.

FW-MWS Special is the Special Conditions column that is a multi-select contact column

]Sigma Design$5] is a cell within the sheet I'm working and the contact name I'm looking for.

Thanks

Erik

Find more posts tagged with

Accepted answers

Dan W

Try This

=SUMIFS({FW-MWS Jobsite Hrs}, {FW-MWS Special}, HAS(@cell, [Sigma Design]$5))

The HAS should do the trick

All comments

Dan W

Try This

=SUMIFS({FW-MWS Jobsite Hrs}, {FW-MWS Special}, HAS(@cell, [Sigma Design]$5))

The HAS should do the trick

Erik Schlemmer

Thanks Dan W. I've been fiddling with the HAS() function, but didn't have it quite right. Your advice fixed it. Appreciate your time.

Erik

Dan W

Happy to help!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.