Counting the Number of Cells Containing Text in a Range

Follow by Email
Facebook
Facebook
Google+
http://www.exceltip.com/counting/counting-the-number-of-cells-containing-text-in-a-range.html">
SHARE




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)

For more information refer to the following link:
http://www.exceltip.com/counting/counting-the-number-of-values-between-two-specified-values-in-a-list.html
http://www.exceltip.com/working-with-formulas/counting-the-number-of-cells-containing-a-substring.html
http://www.exceltip.com/counting/count-the-number-of-cells-containing-data-in-a-range-in-microsoft-excel.html

Please follow and like us:
25


Leave a Reply

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


3 × = nine

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>