countif

Steve Fullmer

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!

Mike Wilday

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 1-100... you can use. 

=COUNTIF([Task Name]:[Task Name], FIND("Hot CX", @cell) > 1)

NOTE: These formulas assume your column name is "Task Name"

Steve Fullmer

Thank You for the help.

Steve Fullmer

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

Mike Wilday

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. 

 

 

Steve Fullmer

Thanks Again!

Mike Wilday

You are welcome. Happy SmartSheeting