countif
Hello, I have a formula that I'm attempting to count the number of projects within the Task Name column that have "hot CX" as part of the name.
Task name is customer Hot CX
My formula returns a 0 count. What changes do I need to make with my formula?
=COUNTIF([Task Name]1:[Task Name]100, "Hot CX")
Thanks!
Comments

Your formula is counting the occurrences of "Hot CX" in the column called Task Name. Because Hot CX isn't the complete name you'll have to integrate a FIND function into your count if. Try this.
=COUNTIF([Task Name]1:[Task Name]100, FIND("Hot CX", @cell) > 1)
Or to look through the entire task name column instead of limiting it to rows 1100... you can use.
=COUNTIF([Task Name]:[Task Name], FIND("Hot CX", @cell) > 1)
NOTE: These formulas assume your column name is "Task Name"

Thank You for the help.

What if "Hot CX" was the complete name? How would the formula change?

Then your original formula would work.
=COUNTIF([Task Name]1:[Task Name]100, "Hot CX") would count every row in the Task Name column from row 1  100, and look for "Hot CX" and count it.

Thanks Again!

You are welcome. Happy SmartSheeting
Help Article Resources
Categories
Check out the Formula Handbook template!