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

    This function returns the number of cells that contain numbers.

    Syntax

    COUNT(value1,value2,...)

    COUNT(array)

    Arguments

    The arguments may be separate values or an array of values. Up to 255 arguments of individual cells may be included.

    Remarks

    This function counts the number of cells that contain numbers in the specified cell range.

    This function differs from COUNTA which also includes text or logical values as well as numbers.

    Data Types

    Accepts cell references. Returns numeric data.

    Examples

    COUNT(B2,B5,B8,D5,D8)

    COUNT(A1:G5)

    COUNT(R6C3:R9C4,2)

    Version Available

    This function is available in product version 2.0 or later.

    See Also

    COUNTA | Statistical Functions