Use `=COUNTIF(range,”*”)` to count cells containing text
Use `=COUNTIF(range,”?*”)` to count cells with at least one text character
Use `=COUNTA(range)-COUNT(range)` to count non-numeric cells, including text
Use `=SUMPRODUCT(–ISTEXT(range))` to count cells that contain text only
Replace `range` with the actual cell range, such as `A1:A100`