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.

Formula:

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.

Result:

 

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