» Count the number of cells containing data in a range in Microsoft Excel
CATEGORY - Counting
VERSION - All Microsoft Excel Versions
Assume Range A1:B15 (14 cells out of the 30 contain data) Use the following function: =COUNTA(A1:B15)
The result: 14
Book Store:
Recommended Books:
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- The Basics of Finance: Financial Tools for Non Financial Managers
- Not-for-Profit Accounting Made Easy
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
No comments have been submitted.
