» 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:
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- Marketing Plan: A Handbook with Marketing Plan
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Accounting and Financial Fundamentals for Nonfinancial Executives
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- How to Use Financial Statements: A Guide to Understanding the Numbers
No comments have been submitted.
