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