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"