COUNT for contact

Eric Laitenberger

Hi,

I would like count the number of contact column.

Could you give me the formula

Christian Graf

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

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)