AREAS
Returns the number of areas in a reference.
Lookup & ReferenceLookup & Matching Essentials
What it does
Returns the number of areas (contiguous ranges) in a reference.
Syntax
AREAS(reference)
Arguments
reference(reference) — A reference to a cell or range of cells.
Examples
Count areas
Count areas in a disjoint range.
FORMULA
=AREAS((A1:B2, D4, E10:F15))
RESULT
3
SAMPLE DATA
| A | |
|---|---|
| 1 | Data |
| 2 | (Refers to cells) |