» Counting the Number of Cells Containing Text in a Range
CATEGORY - Counting
VERSION - All Microsoft Excel Versions
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:
- Marketing Plans That Work, Targeting Growth and Profitability
- Microsoft PowerPoint Version 2002 Step by Step
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Excel 2002 Power Programming with VBA
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
No comments have been submitted.
