# Calculating the number of times a contact name appears in a list

✭✭✭

Hello Community,

I'm trying to calculate the number of times a contact name appears in a list, I've used =CountM, =Count, =Find, =Sum but in the end i keep getting 'error'. Please help!

• ✭✭✭✭✭✭

Ah!

Your contact column is a multiselect. So we'll need to modify the formula to allow for that...

=COUNTIF([Contact Column]:[Contact Column],HAS(@cell, "Kate Condon"))

We use the HAS function for multiselects.

Ryan Sides

Come Say Hello!

• ✭✭✭✭✭✭

Hey Kate. You'll use the COUNTIF function.

=COUNTIF([Contact List]:[Contact List], "Kate Condon")

Ryan Sides

Come Say Hello!

• ✭✭✭

Thank you Ryan, this worked more than the others I had tried though it doesn't count all of the times a name appears, it's just showing 1 rather than 6. Any other solutions?

• ✭✭✭✭✭✭
edited 02/01/23

Do you have your contact column setup as a contact type?

Ryan Sides

Come Say Hello!

• ✭✭✭

Yes, I do

• ✭✭✭✭✭✭

Can you post screenshots of everything here? Your list of names, your formula, etc.?

Ryan Sides

Come Say Hello!

• ✭✭✭

My name 'Kate Condon' is on every project so it should be counting it 13 times (the number of total rows in this column) Does it require a different formula because it's in summary?

• ✭✭✭✭✭✭

Ah!

Your contact column is a multiselect. So we'll need to modify the formula to allow for that...

=COUNTIF([Contact Column]:[Contact Column],HAS(@cell, "Kate Condon"))

We use the HAS function for multiselects.

Ryan Sides

Come Say Hello!

• ✭✭✭

It worked!! Thank you so much for your help Ryan!

• ✭✭✭✭✭✭

You bet! :)

Ryan Sides