Excel AREAS function

Function              AREAS

Description        Excel AREAS function returns the number of areas in a reference. An area is a range of cells or a single cell.

Syntax  AREAS(reference)

Reference    A reference to a cell or range of cells or set of range of cells.

Example:

=AREAS((B5:C8)) // returns 1

=AREAS((E2:T14,B2:R24)) // returns 2

=AREAS((J27:L45,E59:K78,U12)) // returns 3