Counting the Number of Cells Containing Text in a Range





The COUNTA formula returns the number of cells that contain any type of data in a range.

The COUNT formula returns the number of cells that contain only numeric data in a range.

Subtracting the two formulas will return the number of cells that contain text in the range defined by the Name table:

=COUNTA(Table)-COUNT(Table)
Screenshot // Counting the Number of Cells Containing Text in a Range
Counting the Number of Cells Containing Text in a Range



Leave a Reply

Your email address will not be published. Required fields are marked *


seven − 2 =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>