Friday, June 29, 2007
Text Search Count
If you want to do a text search count in a range, you can use the following formulas:
Where D3 is the search text and the range A2:A16 houses the data.
An array formula using SUM and SEARCH
Another using COUNTIF:
This picture might make it clear:
Where D3 is the search text and the range A2:A16 houses the data.
An array formula using SUM and SEARCH
{=SUM(IF(ISERROR(SEARCH(D3,A2:A16)),0,1))}
Another using COUNTIF:
=COUNTIF(A2:A16,"*"&D3&"*")
This picture might make it clear:
Labels: String Operations
