count if with contains

=COUNTIFS({Current PM Master Model}, CONTAINS("Access 2", {Current PM Master Model}), {Current PM Master Territory}, District@row, {Current PM Master Reason Code}, false, {Current PM Master outside}, true)

I referenced the sheet and then did contains but it's returning zero even though I know it should return 1. I know the problem is the contains part due to troubleshooting. Can someone let me know if you see something wrong.

Find more posts tagged with

Accepted answers

All comments

Kelly Moore

Hey @frob

Try this

=COUNTIFS({Current PM Master Model}, CONTAINS("Access 2",@cell), {Current PM Master Territory}, District@row, {Current PM Master Reason Code}, false, {Current PM Master outside}, true)

Will this work for you?

Kelly

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.