To find out how many times the contact is mentioned

Christophe AUBRIOT · 07/09/21

Hello,

I know the subject has already been mentioned but I can't solve my problem. Because a cell can contain several contacts.

I am trying to find out how many times the contact "Franck Debucquet" is mentioned in a column.

Sometimes a cell can contain several contacts.

See example below

:

Thanks !

Bassam Khalil · 07/09/21

Hope you are fine, please try the following formula:

=COUNTIFS(Contact:Contact, HAS(@cell, "Franck Debucquet"))

the following screenshot shows the result

Bassam Khalil · 07/09/21

Hope you are fine, please try the following formula:

=COUNTIFS(Contact:Contact, HAS(@cell, "Franck Debucquet"))

the following screenshot shows the result

Best Answer