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)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment