# Countif / Countm ?

Options
✭✭
edited 01/21/21

Hello everyone, I take the liberty of contacting you because I am trying to count the number of times the name "Sophie" appears in a column. But you should know that in a cell can be several names like Robert Peter Sophie Léa... I tried this formula which seemed to me the most consistent :

=COUNTIF(COUNTM({Range});Criterion))

I know that on excel the formula looks like :

=SUMPRODUCT((ISNUMBER(SEARCH(Sophie, range)))*1)

If you have an idea, I'm interested. And I'm sorry for my english....

Cordialy,

azerty64

• ✭✭✭✭✭✭
Options

Hey

It sounds like you have a multi-select contact column. If yes, try this

=COUNTIFS({range}, HAS(@cell, "specific person"))

Change to the specific person name you need or use [person]@row (without any quotes) if all the names are in a list on your target sheet. When using a specific person you will need to be mindful whether smartsheet is listing the name as a Contact name, or an email address - write it exactly the way that smartsheet does

• ✭✭✭✭✭✭
Options

The below should do the trick. Replace 'column' with your column name.

=COUNTIF([Column]:[Column], HAS(@cell, "Sophie"))

• ✭✭✭✭✭✭
Options

Hey

It sounds like you have a multi-select contact column. If yes, try this

=COUNTIFS({range}, HAS(@cell, "specific person"))

Change to the specific person name you need or use [person]@row (without any quotes) if all the names are in a list on your target sheet. When using a specific person you will need to be mindful whether smartsheet is listing the name as a Contact name, or an email address - write it exactly the way that smartsheet does

• ✭✭✭✭✭✭
Options

The below should do the trick. Replace 'column' with your column name.

=COUNTIF([Column]:[Column], HAS(@cell, "Sophie"))

• ✭✭
Options

Hello @KDM & @Leibel S

I apologize for the delay in response !

Thank you for your solutions, they correspond to what I expected !!!

THANK YOU ! 😀

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!