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.