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

Kate Condon

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!

Ryan Sides

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

@Kate Condon

Hey Kate. You'll use the COUNTIF function.

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

Kate Condon

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?

Ryan Sides

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

Kate Condon

Yes, I do

Ryan Sides

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

Kate Condon

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?

Ryan Sides

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.

Kate Condon

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

Ryan Sides

You bet! :)