|  

» Count the number of cells in a range in Microsoft Excel

CATEGORY - Counting VERSION - All Microsoft Excel Versions
Assume Range A1:B15

Use the following function to count the number of cells in the range
=ROWS(A1:B15)*COLUMNS(A1:B15)

The result: 30

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