COUNTIF Multiple Select Row

I am trying to count all of the instances One Value is showing up in the assigned row even if two people are assigned to the same row. This is the equation I came up with but I keep getting zero even though there is actually one with that value combined with another value. What am I doing wrong?

=COUNTIFS({Project Oversight Range 5}, (CONTAINS("Mike Buckiewicz", @cell)))

A variation of this equation worked to count if there was one selection only in the column but is not calculating when there are multiple.

Please help!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!