Sheet Summary Formula

I have a formula question that I’m hoping you can help me with. I have a multi-select drop-down in the Stakeholder Department(s) column, which contains several department names. I’m trying to create a sheet summary that counts the number of times any one of these department names appear in that column. I’m currently using the following – and it’s not working. (It looks like it might only be counting the first entry in each cell in that column.) =COUNTIF([Stakeholder Department(s)]1:[Stakeholder Department(s)]35, "Business Ops.") Any advice on how to achieve this?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!