Tip Printed from ExcelTip.com
Count the number of cells with numeric data in a range in Microsoft Excel
Assume Range A1:B15
(only 7 cells have numeric data)
Use the following function:
=COUNT(A1:B15)
The result:
7