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

    This function returns the number of areas in the specified reference.

    Syntax

    AREAS(reference)

    Arguments

    Specify the cell reference for the argument.

    Remarks

    In this function, single argument can refer to multiple areas. To do so, extra set of parentheses is used.

    Data Types

    Accepts cell reference for argument. Returns numeric data.

    Examples

    AREAS(B7:D9) gives the result 1

    AREAS((B2:D4,E5,F6:I9)) gives the result 3