COUNTIF + CONTAINS - how do I incorporate them both?


I'm trying to count how many times a value is used in a column. Sometimes the values are alone, sometimes there are multiple in a cell.

I got my COUNTIF formula down: =COUNTIF({Christoph Comms Tracker Audience Category}, "Select SMG Employees")

But I want to change it so it counts cells that include the value (along with other values).

So, if we're using the screenshot below, I want the formula to count 3 Analysts, 2 Media, 3 SMG Employees, etc.

I tried to incorporate CONTAINS, but I'm getting "Incorrect Arguement Set" (formula below)

=COUNTIF({Christoph Comms Tracker Audience Category}, CONTAINS("Select SMG Employees"))

Am I placing it wrong?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!