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

Melitta

=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?

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!

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!

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!