SpreadJS 14
Formula Reference / Formula Functions / Statistical Functions / COUNTIF
In This Topic
    COUNTIF
    In This Topic

    This function returns the number of cells that meet a certain condition.

    Syntax

    COUNTIF(cellrange,condition)

    Arguments

    This function has these arguments:

    Argument Description
    cellrange Range of cells to count; cell range reference
    condition Condition that determines which cells are counted, as a text, number, or expression

    Data Types

    Accepts cell range reference. Returns numeric data.

    Examples

    COUNTIF(A1:G5,"test")

    COUNTIF(R6C3:R9C4,"<2")

    See Also