Problem using countif to find second contact in the same field....

JWood

I have a column where I can add contacts from our integrated address list.

When I use "countif" to count the number of times a contact appears in the column, it works fine if only one contact is listed in the fields in the column.

If I add a second contact to some of the fields in the column and try to use "countif" to count those second contacts, it returns a "0".

For instance if the field contains "John Doe, Jane Doe", the countif can be used to count the number times of John Doe appears in the column, but a similar countif looking for "Jane Doe" returns a "0", even though the second contact is separated by a comma.

Any ideas welcome.....

SteyJ

https://community.smartsheet.com/discussion/117611/problem-using-countif-to-find-second-contact-in-the-same-field

Try this one out:

=COUNTIF([Contact Column]:[Contact Column], HAS(@cell, "Bob John"))

JWood

Thank you!

Linda Manduchova

Hello @JWood -

Try the following formula:

=COUNTIFS([Contact Field]:[Contact Field], FIND("Jane", @cell) > 0)

Linda