Count/Countif/Countifs - contents contain xxx

Hi there, I am trying to create a count/countif/countifs formula where only part of the data is in the column I want to include. Can you please help with this.

For example if the cell data states F24 today budget planning and another cell says F24 tomorrow budget planning.

I need to create a formula that says if it contains "F24 today" then count it. Meaning contains F24 today

Thank you

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!