Spread.NET 17 Formula Reference
Formula Functions / Functions A to C / COUNTBLANK
In This Topic
    In This Topic

    This function returns the number of empty (or blank) cells in a range of cells on a sheet.




    This function takes a cell range reference or array as an argument.


    This function counts the number of empty or blank cells in the specified cell range on one sheet. This function does not count cells containing an empty string "". A cell is empty if the cell's Value is null (Nothing in VB). Note that there is a difference being a cell's Value being null and a cell's Value being the empty string "". For example, consider the following Spread code in C#:

         spread.Sheets[0].Cells[0,0].Value = null; // empty

         spread.Sheets[0].Cells[1,0].Value = ""; // string

         spread.Sheets[0].Cells[2,0].Value = "abc"; // string

         spread.Sheets[0].Cells[3,0].Value = 123.0; // number

         spread.Sheets[0].Cells[4,0].Formula = "COUNTBLANK(A1:A4)";

    The formula in cell A5 evaluates to 1 because cell A1 is the only cell in the range A1:A4 that is empty.

    Note: Spread's implementation of functions generally tries to follow the behavior found in popular spreadsheet applications. However, not all these applications agree whether the empty string "" should be treated the same as an empty cell. In Spread, both the COUNTBLANK and ISBLANK functions consistently treat the empty string "" differently than an empty cell.

    Data Types

    Accepts cell range reference. Returns numeric data.




    Version Available

    This function is available in product version 1.0 or later.

    See Also

    COUNTIF | ISBLANK | TYPE | Information Functions