Trying (without success) to use a contains with a Countif when referencing another sheet

When I try this statement:

=COUNTIF({PM Assigned}, [PM Name]@row)

I get the number 55 - which is correct. The number of cells that EQUAL that value are 55

BUT I am looking for the number of cells that contain that value (Should be 56), but I have had zero luck with all of the combinations I have tried.

Any help?

To state I am looking for a count of the cells in the range {PM Assigned} that contain the string in the [PM Name] column of this row. - Count should be 56

Note: The {PM Assigned} range is a column with the type of dropdown

Find more posts tagged with

Formulas

Accepted answers

All comments

AKnight

Hey @CSPearsall !

Have you tried adding HAS to the second portion of your formula? Like:

=COUNTIF({PM Assigned}, HAS(@cell, [PM Name]@row))

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.