Excel Hack 56: Count the number of instances of a string with other text in a range (array formula)
(Short tutorial alert) If you needed to count the number of times a certain string appeared in a range, the COUNTIF() function would be able to do that, seamlessly. But what happens when there are other text alongside that string in the cells in the range? The COUNTIF function works with the assumption that the