» 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:
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Investing for Dummies, Third Edition
- Microsoft Office XP Introductory Concepts and Techniques
- Accounting Principles, with CD, 6th Edition
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
No comments have been submitted.
