Excel AREAS Function

Excel AREAS Function

Sponsored Link


Get the number of areas in a reference.

Return value 

A number representing number of areas.


=AREAS (reference)


  • reference – A reference to a cell or range of cells.

Usage notes 

Reference can include more than one reference. you must separate multiple references with a comma and wrap then in an extra set of parentheses. Otherwise, Excel will think the commas indicate multiple parameters and generate an error.

As an example, the formula =AREAS((F17:F19,J16:J18,I8)) will return 3.

Sponsored Link

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas