Countif containing specific text



I am trying to count to see how often a specific word, in this case a person's name, appears in a range of text. I've looked over similar questions and have started a formula, but I end up with an #INVALID OPERATION error.

My formula is

=COUNTIF({January Range}, FIND("Cassie", @cell, > 0))

I've also tried

=COUNTIF({January Range}, FIND("Cassie", @cell > 0))

Which instead gives me #INVALID DATA TYPE error.

Thank you for any help with this!

Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!