COUNT for contact


I would like count the number of contact column.

Could you give me the formula


  • Christian Graf
    Christian Graf ✭✭✭✭✭

    Hi there,

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


    Or excluding duplicates?


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