AREAS
Description
Returns the number of areas in the specified reference or list of references.
Syntax
AREAS(
reference
)
- reference: The reference (cell) or list of references (range of cells).
Example
Formula | Result |
|---|---|
=AREAS((A1:B2,C3:D5)) | 2 |
=AREAS(1:1) | The number of the maximum column that has ever been used on the current
sheet. |
Related Functions
ARRAYAREA
GROUPBY