Click the Insert function button fx under formula toolbar a dialog box will appear. The COUNTIF function below counts the number of cells that are equal to 20. Criteria specifies the condition that a particular cell content should meet to be counted.
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.
The COUNTIF function below counts the number of cells that are equal to 20. How to use COUNTIF in Excel Criteria as text string. COUNTIF range Because the asterisk is a wildcard that matches any sequence of characters the formula counts all cells that contain any text. Use COUNTIF one of the statistical functions to count the number of cells that meet a criterion.