Counting persons in "Assigned To" Column

Cindi Meche

Hi! I'm trying to count the number of times a person shows up in an "Assigned To" column. I have Sara, Sally, and Simon. For some reason, my formula returns 0 even though I have 2 "Sara"s, 4 "Sally"s, and 1 "Simon".

=COUNTIF({Other project Range 2}, FIND("Sara", @cell) > 0)

What could be missing?

Thanks ~ Cindi

Cindi Meche

I think it may be partially user error? I got it to work by going by through every portion of the equation... this is what is now working:

=COUNTIF({MASTER - Marketing Projects '21 Range 7}, FIND("Sara", @cell) > 0)

Cindi Meche

I may have answered my own question. I removed and it's working now...

Cindi Meche

Nope :( It's not.

Andrée Starå

Hi @Cindi Meche

I hope you're well and safe!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Genevieve P.

Hi @Cindi Meche

I agree that it would be helpful to see a screen capture! Would you also be able to identify what type of column you're using for the Assigned To column, is it a Contact List? Does it allow for multiple selections?

Instead of using FIND, try CONTAINS:

=COUNTIF({Other project Range 2}, CONTAINS("Sara", @cell))

You also don't need the >0 at the end. It will bring back a COUNT but only IF the cell contains "Sara". Does that make sense?

Cheers,

Genevieve

Cindi Meche

I think it may be partially user error? I got it to work by going by through every portion of the equation... this is what is now working:

=COUNTIF({MASTER - Marketing Projects '21 Range 7}, FIND("Sara", @cell) > 0)

Andrée Starå

@Cindi Meche

Excellent!

Glad you got it working!

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!