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