Countif Formula in Contact Column

Dryden

I have created a summary sheet and one of my formulas is counting the number of times an email address appears in the column.

The formulas work when the column is "Text/Number" column, however, if I change it to a "Contact Column" the formula returns a 0 value which is not correct.

This is the formula (I have removed the email address for data protection reasons and replaced it with N/A). =COUNTIF([Chief Officer]:[Chief Officer], CONTAINS("N/A", @cell)).

It worked as a contact column previously, but decided to stop when I added new contacts to the list.

Samuel Mueller

Try replacing Contains() with Find(criteria,criteria) > 0

Samuel Mueller

Try replacing Contains() with Find(criteria,criteria) > 0

Dryden

Many thanks Samuel,

This worked a treat, appreciate your help on this one!