AREAS(list)

The AREAS function calculates the number of areas in a reference or list of references. An area is a range of cells that are contiguous, including a single cell.

For example:

AREAS(A1..D3, E10)

returns 2.

See also:

Other lookup functions