Sum If and Contain Formula

Hello,

I am trying to figure out how many hours imp manager is working for an assigned project.

This formula works: =SUMIF({Implementation Opportunities Range 9}, "A", {Implementation Opportunities Range 10}

However, I tried to apply it to a new sheet where the imp manager is a multiple drop down and more than one manager can be selected per project. It's only picking up the cells that JUST have the "A" manager.

I tried to use CONTAINS and came up with this, but its not working:

=SUMIF({Implementation Opportunities Range 9}, {Implementation Opportunities Range 10}, Contain("A", @cell))

Any suggestions?

Find more posts tagged with

Accepted answers

MedaUser

Actually, try this @Mkaur:

=SUMIF({Implementation Opportunities Range 9}, HAS(@cell, "A"), {Implementation Opportunities Range 10})

All comments

MedaUser

Hi @Mkaur,

What is the Column Type for your manage column? Is it a Contact List or Dropdown list?

MedaUser

Actually, try this @Mkaur:

=SUMIF({Implementation Opportunities Range 9}, HAS(@cell, "A"), {Implementation Opportunities Range 10})

Mkaur

@MedaUser Thank you for your suggestion, that worked for me :)!

MedaUser

No problem! 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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.