Site icon ExcelNotes

How to Count Text Cells with a Number of Characters

To count the number of text cells with some characters, you can use the COUNTIF function with the wild card of the question mark (?), where the question mark represents one character.

Example: You are working on a database with the city name in column A, the region in column B, and the temperature in column C.

Formula: How many cells are text with four characters in A2:C12?

=COUNTIF(A2:C12,"????")

The question mark (?) is used in the formula to represent one character, and six cells are text with four characters.

Please note that the formula will count cells with only spaces as text cells.

Notes: The COUNTIF Function

Formula:

=COUNTIF(Range, "????")

Explanations:

– The range is required, which will be the range of cells that you want to count;
– The question mark (?) is required, representing one character.

Exit mobile version