✳flâneur — a map of the web's best reading

Excel formula: Count cells that contain text | Exceljet

exceljet.net · 713 words · saved by 1 readers

COUNTIF counts the number of cells that match the supplied criteria. In this case, the criteria is supplied as the wildcard character "*" which matches any number of text characters.

Summary To count cells in a range that contain text values , you can use the COUNTIF function and the asterisk (*) wildcard . In the example shown, the formula in cell H5 is: =COUNTIF(data,"*") where data is the named range B5:B15. The result is 4 because four cells in the range B5:B15 contain text values. Related formulas: Count cells with specific text , Count cells that are not empty . Generic formula =COUNTIF(range,"*") Explanation In this example, the goal is to count cells in a range that contain text values. This could be hard-coded text like "apple" or "red", numbers en

Explore this link on the map →

related reading