Spread Formula Reference
Formula Functions / Functions A to C / 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

    Version Available

    This function is available in Spread for Windows Forms 11.0 or later.