AREAS Function Explained

The AREAS function in Microsoft Excel returns the number of areas in a reference. It can be used to return the number of ranges in a reference or the number of individual cells in a multi-cell reference. It takes a single argument, which is a reference to a range of cells.

AREAS Function Syntax

AREAS(reference)

  • reference: A reference to a range of cells. The reference must include at least two areas.