Skip to Content

AREAS

Returns the number of areas in a reference

Syntax

AREAS(reference)

Parameters

  • reference: Required. A reference to a cell or range of cells and can refer to multiple areas

Example

=AREAS((A1:B4, C5:D8))
Returns: NumberSince: Excel 2003