COUNTIFS functionality for multiple entries

New to SmartSheet and I promise I have been looking around for an answer, but without any luck so I thought I would throw it out to the community...

I am looking to sum up all entries in column in a summary total at the top of my sheet, but the formula I have is only calculating where the searched for text is alone in the cell, not where it's combined with other text.

My end goal is to sum up the number of times each list is used, so maybe I have the complete wrong formula entirely.

This is the formula that I am currently using =COUNTIF([Marketing List]:[Marketing List], "NY_Office Leasing")

Thanks for your time!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!