CountIF with multiple values in the same cell (same sheet)



I'm using a CountIf formula in Sheets Summary to count how many times a project manager (using the contact list for my column) is assigned in this year's strategic initiatives. I was able to get it to work with one person per cell, however, I can't figure it out when their's multiple people per cell.

Current formula: =COUNTIF([Project Manager]:[Project Manager], "Name")😀

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!