» Count the number of cells with numeric data in a range in Microsoft Excel
CATEGORY - Counting
VERSION - All Microsoft Excel Versions
Assume Range A1:B15 (only 7 cells have numeric data)Use the following function: =COUNT(A1:B15)
The result: 7
Book Store:
Recommended Books:
- Dictionary of Finance and Investment Terms
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Investing in Real Estate, Fourth Edition
No comments have been submitted.
