AREAS

Syntax:

AREAS ( reference )

Description: Finds the number of areas (§3.17.2.3) designated by reference.

Arguments:

Name

Type

Description

reference

reference

A reference to a single cell or to a range of cells that can refer to multiple areas.

Return Type and Value: number – The number of areas designated by reference.

However, if the reference designates no areas, #NUM! is returned.

example: