How To Count Text In Excel?

Use `=COUNTA(range)` to count cells that contain text

Use `=COUNTIF(range,”*”)` to count cells with text only

Use `=COUNTIF(range,”<>“)` to count non-empty cells, including text and numbers

Use `=SUMPRODUCT(–ISTEXT(range))` to count only text cells

Use `=LEN(cell)` to count the number of characters in a text cell

Use `=COUNTIF(range,”*text*”)` to count cells containing specific text

Use `=COUNTIFS(range1,”*”)` to count text across multiple criteria ranges

Use `=FILTER(range,ISTEXT(range))` to return only text cells before counting them

Use `=SUBTOTAL(103,range)` to count visible non-empty cells in filtered data

Use `=ROWS(FILTER(range,ISTEXT(range)))` to count text cells in Excel 365 or Excel 2021