Spread Formula Reference
Formula Functions / Functions A to C / COLUMNS
In This Topic
    COLUMNS
    In This Topic

    This function returns the number of columns in an array.

    Syntax

    COLUMNS(array)

    Arguments

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

    Data Types

    Accepts cell references or array. Returns numeric data.

    Examples

    COLUMNS(B6:D12) gives the result 3

    COLUMNS(R6C2:R12C4) gives the result 3

    COLUMNS($B$8:$H$8) gives the result 7

    COLUMNS(R[2]C[1]:R[3]C[8]) gives the result 8

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    ROWS | INDEX | Lookup Functions