Use the COUNTIF function to count cells that contain [n] characters. In our example, we will count cells that contain five characters/ alphabets.
The formula used above has following arguments:
range (A5:A9) – The range of cells to count against the criteria.
criteria (??????) – The criteria to sum only six alphabets.