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: