Count number of contacts

Michal Holtz

Hi,

I need to find how many times a specific team member appears in multiple contacts cell. I understand that Contains doesn't work on this kind of cell so I tried HAS but I don't get the expected results.

=COUNTIFS(Lead:Lead, HAS(@cell, Team1))

Any idea?

Thanks

Michal Holtz

Another solution that worked for me;

=COUNTIFS(<Column Name>, FIND("<replace name>", @cell) > 0)

Thanks

Leibel S

@Michal Holtz

Are both these columns Contact columns?

If yes, it should work using the HAS function as you've described.

Michal Holtz

Yes, both are Contacts. Doesn't work

Michal Holtz

Another solution that worked for me;

=COUNTIFS(<Column Name>, FIND("<replace name>", @cell) > 0)

Thanks