<< Click to Display Table of Contents >> AREAS (number of areas)

Syntax:

AREAS(reference)

Description:

This determines how many cell ranges the specified cell reference contains.

Example:

AREAS(A1:B2) returns 1

AREAS((A1:B2, E5:G7)) returns 2

See also:

INDEX, COLUMNS, ROWS