COUNTIFS in a multi-select contact column

Wendy Young

I am trying to count the number of times a name appears in a multi-select contact column, however, none of the proposed formulas are working. Please advise.

Thank you!

Wendy

Paul Newcome

Try something like this:

=COUNTIF([project team]:[project team], FIND("Ed Brandt", @cell) > 0)

Paul Newcome

Happy to help! 👍️

Please don't forget to mark the most appropriate response(s) as "helpful". This will let others searching for a similar solution know that one may be found here.

Paul Newcome

What formulas have you tried thus far and what are the issues with them?

You should be able to use a FIND function inside of a COUNTIFS.

Wendy Young

I've tried a few. Mainly, =COUNTIF(project team:project team, FIND("Ed Brandt"), >0,@cell)

Wendy Young

Project Team is my contact list column.

Paul Newcome

Try something like this:

=COUNTIF([project team]:[project team], FIND("Ed Brandt", @cell) > 0)

Wendy Young

Worked PERFECTLY!!! Thank you so much!!

Paul Newcome

Happy to help! 👍️

Please don't forget to mark the most appropriate response(s) as "helpful". This will let others searching for a similar solution know that one may be found here.