Spread Formula Reference
Formula Functions / Functions R to S / ROW
In This Topic
    ROW
    In This Topic

    This function returns the number of a row from a reference.

    Syntax

    ROW(reference)

    Arguments

    The argument is a cell or a single area.

    Remarks

    If the reference is omitted, the reference of the cell that the function is in is used.

    Data Types

    Accepts a cell or a single area. Returns numeric data.

    Examples

    ROW(B2) gives the result 2

    ROW(B1:B5) gives the result 1

    Version Available

    This function is available in product version 3.0 or later.

    See Also

    COLUMNS | INDEX | Lookup Functions