Problem using countif to find second contact in the same field....
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.....
Answers
-
Try this one out:
=COUNTIF([Contact Column]:[Contact Column], HAS(@cell, "Bob John"))
Sincerely,
Jacob Stey
-
Thank you!
-
Hello @JWood -
Try the following formula:
=COUNTIFS([Contact Field]:[Contact Field], FIND("Jane", @cell) > 0)
Linda
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives