Exceljet

Quick, clean, and to the point

Excel AREAS Function

Excel AREAS function
Summary 

The Excel AREAS function returns the number of areas in a given reference. For example, =AREAS((A1:C1,A2:C2)) returns 2. Multiple references must be enclosed in an extra set of parentheses.

Purpose 
Get the number of areas in a reference.
Return value 
A number representing number of areas.
Syntax 
=AREAS (reference)
Arguments 
  • 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 arguments and generate an error.

Example:

=AREAS((A1:C1)) // returns 1
=AREAS((A1:C1,A2:C2)) // returns 2
=AREAS((F17:F19,J16:J18,I8)) // returns 3
500 Formula Examples, thoughtfully explained.