Lookup/CountIF Formulas for Multi-Select ranges



We are referencing another sheet and are wanting to know how many times the word "SNAP" appears in the multi-select cells within a row. Right now, this is what we have, but it won't work. We have tried multiple different formulas as well and cannot seem to find anything to count the number of time "SNAP" shows up in the Focus Areas column.

Any help would be appreciated. Thank you in advance.

=COUNTIFS({Contacts with Demos Range 2}, [Focus Areas]:[Focus Areas], "SNAP"))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!