How to count "Contact" cells with multiple contact per cell

There is a contact column where multiple contacts per cell are allowed. How can I count the total number of rows that contain a specific name? Is it possible to combine COUNTIFS & CONTAINS?

=COUNTIFS({Responsible}, {Status}, "NEW", {Responsible}, CONTAINS("Dmitry Gorobets", {Responsible}))

The formula returns 0, but the value should be much bigger. Does CONTAINS formula work with contact columns?

Find more posts tagged with

Formulas

Accepted answers

All comments

Bassam Khalil

Hi @Aliaksandr Ilyuk

Hope you are fine, please try the following formula:

=COUNTIFS({Status}, @cell = "New", {Responsible}, HAS(@cell, "Dmitry Gorobets"))

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.