|  

» 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


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