|  

» 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


Rate This Tip
12 34 5
Rating: 3.09     Views: 18523
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments