“COUNTBLANK function (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Excel.
Counts empty cells in a specified range of cells.
COUNTBLANK(range)The COUNTBLANK function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):
Range Required. The range from which you want to count the blank cells.
Cells with formulas that return “””” (empty text) are also counted. Cells with zero values are not counted.
This Excel tutorial has been created to help you learn microsoft excel online. On http://www.myelesson.org you get excel help and online file download facitity. This video lesson covers the entire topic in simple and easy to understand step by step approach. ”