Multiple contacts in one cell count


I am looking to count a specific contact within a cell that has multiple contacts but I would also like to ensure the count is for a specific criteria. For example

Joe Smith and Jane Doe are in the same cell but I want to count how many times Joe smith appears in the smartsheet while also ensuring he is meeting an additional criteria in another column as "in progress".

I am trying countif function with a find function but am having no luck.

any assistance would be greatly appreciated.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!