COUNT for contact

Hi,


I would like count the number of contact column.

Could you give me the formula

Answers

  • Christian Graf
    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]))

  • 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)