Formulas and Functions
Modifying this control will update this page automatically

AREAS

The AREAS function returns the number of ranges the function references.

AREAS(areas)

areas: The areas the function should count. areas is a list value. It is either a single range or more than one range separated by commas and enclosed in an additional set of brackets; for example, AREAS((B1:B5,C10:C12)).

Examples

=AREAS(A1:F8) returns 1.

=AREAS((A1:F8, A10:F18)) returns 2.

=AREAS((A1:C1, A3:C3, A5:C5)) returns 3.

Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.