COUNT for contact

Eric Laitenberger · 04/28/22

Hi,

I would like count the number of contact column.

Could you give me the formula

Christian Graf · 04/28/22

Hi there,

Are you trying to count the number of contacts in the column including duplicates?

COUNT([Contact]:[Contact])

Or excluding duplicates?

COUNT(DISTINCT([Contact]:[Contact]))

Marion Dubois · 10/28/22

Alternatively if you're counting the number of time each contact appear in a grid use the below:

In a separate grid, list all your contact on a separate row then use the formula:

=COUNTIF({range with the contact names}, FIND(Contact@row, @cell) > 0)

Answers