Tip Printed from ExcelTip.com
Count the number of cells containing data in a range in Microsoft Excel
Assume Range A1:B15
(14 cells out of the 30 contain data)
Use the following function:
=COUNTA(A1:B15)
The result:
14