Looking to Countif a person's name is contained in a column that allows for multiple contacts.

=COUNTIFS({OTP Goals Project Lead}, CONTAINS(Contact@row))

the OTP Goals Project Lead is the sheet that has the column that is a contact list that allows for multiple contacts. If a person's name is contained in that column and it matches the name in the column on the metrics sheet called Contact - then I want it to count how many times that name appears.

It's replying with Incorrect Argument Set.

Anyone using Countif with Contains?

Find more posts tagged with

Formulas

Accepted answers

Andrée Starå

Hi @Melitta

I hope you're well and safe!

Try something like this.

=COUNTIFS({OTP Goals Project Lead}, CONTAINS(Contact@row,@cell)

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

All comments

Andrée Starå

Hi @Melitta

I hope you're well and safe!

Try something like this.

=COUNTIFS({OTP Goals Project Lead}, CONTAINS(Contact@row,@cell)

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Melitta

Hello @Andrée Starå,

That works, thanks.

I'll look up the @cell so I understand when to use that.

I appreciate your help,

Melitta

Andrée Starå

@Melitta

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

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.