Countif Formula In Excel For Text. When you wish to find the number of cells with text in excel the countif function with an asterisk in the criteria argument is the best and easiest solution. Microsoft excel has a special function to conditionally count cells the countif function.
Countif range because the asterisk is a wildcard that matches any sequence of characters the formula counts all cells that contain any text. Here s a generic excel formula to count number of cells containing specific text. Cell b2 contains the formula countif ages a2 cell b3 countif ages a3 etc.
Combo formula using countif with wildcard characters to count cell with text values the best formulas to count cells with text is countif with wildcard character asterisk.
Showing one condition only for simplicity. You can also use sumproduct to count text values along with the function istext like so. The result is 3. Showing one condition only for simplicity.
