Explainry Tutorials to Expert in IT

Count cells that contain [n] (e.g. five) characters

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.



Copyright © 2016 - 2020 Explainry.com | All Rights Reserved