SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / ROWS
In This Topic
    ROWS
    In This Topic

    This function returns the number of rows in an array.

    Syntax

    ROWS(array)

    Arguments

    The argument is an array, an array formula, or a range of cells.

    Data Types

    Accepts array. Returns numeric data.

    Examples

    ROWS(B2:B14) gives the result 13

    ROWS(R2C6:R4C12) gives the result 3

    ROWS($H$2:$H$8) gives the result 7

    ROWS(R[2]C[3]:R[8]C[3]) gives the result 7

    ROWS(R3C2:R17C2) gives the result 15

    See Also