Countif / Countm ?

Hello everyone, I take the liberty of contacting you because I am trying to count the number of times the name "Sophie" appears in a column. But you should know that in a cell can be several names like Robert Peter Sophie Léa... I tried this formula which seemed to me the most consistent :

=COUNTIF(COUNTM({Range});Criterion))

I know that on excel the formula looks like :

=SUMPRODUCT((ISNUMBER(SEARCH(Sophie, range)))*1)

If you have an idea, I'm interested. And I'm sorry for my english....

Cordialy,

azerty64

Find more posts tagged with

Accepted answers

Kelly Moore

Hey

It sounds like you have a multi-select contact column. If yes, try this

=COUNTIFS({range}, HAS(@cell, "specific person"))

Change to the specific person name you need or use [person]@row (without any quotes) if all the names are in a list on your target sheet. When using a specific person you will need to be mindful whether smartsheet is listing the name as a Contact name, or an email address - write it exactly the way that smartsheet does

Leibel S

The below should do the trick. Replace 'column' with your column name.

=COUNTIF([Column]:[Column], HAS(@cell, "Sophie"))

All comments

Kelly Moore

Hey

It sounds like you have a multi-select contact column. If yes, try this

=COUNTIFS({range}, HAS(@cell, "specific person"))

Leibel S

The below should do the trick. Replace 'column' with your column name.

=COUNTIF([Column]:[Column], HAS(@cell, "Sophie"))

azerty64

Hello @KDM & @Leibel S

I apologize for the delay in response !

Thank you for your solutions, they correspond to what I expected !!!

THANK YOU ! 😀

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.