» Counting the Number of Cells Containing Text in a Range
CATEGORY - Counting
VERSION - All Microsoft Excel Versions
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)
Book Store:
Recommended Books:
- Microsoft Windows XP Registry Guide
- Financial Statement Analysis with S&P insert card
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Microsoft Windows XP Inside Out
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- The Guide to Understanding Financial Statements
No comments have been submitted.
