|  

» 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.10     Views: 24515
No comments have been submitted.
Name
Comment Title
Comments