COUNT_TEXT

Count of text values in cells, ranges, or data fields. Non-text values (numbers, dates, blanks/empty cells, Booleans, errors) are ignored.

Function syntax

COUNT_TEXT(input1, ...)

Arguments:

• input1, …: One or more text values, cells, ranges, or data fields.

Examples

• COUNT_TEXT(A1:A5) - If A1:A5 contains apple, 10, banana, (empty cell), apple, returns 3. Numbers, dates, Booleans, errors, and blanks/empty cells are ignored.
• COUNT_TEXT(country{}) - Count of values in the (text) country field. Blanks are not counted.
• COUNT_TEXT(country{region{“EMEA”}}) - Count of values in the country field where region is EMEA.
• COUNT_TEXT(country{}, C10:E15) - Count of text values across the country field and the range C10:E15 combined.