areas
Number of distinct ranges in a reference.
Syntax
Section titled “Syntax”v = areas(reference)Description
Section titled “Description”Returns the count of disjoint regions in a multi-area reference. For a single contiguous range, returns 1.
Example
Section titled “Example”areas((A1:B5, D1:E5, G1)) % 3See also
Section titled “See also”index— Element of an array by row and column position.