Tip Printed from ExcelTip.com

---

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)