Quick, clean, and to the point

Excel AREAS Function

Excel AREAS function

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.

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 arguments and generate an error.


=AREAS((A1:C1)) // returns 1
=AREAS((A1:C1,A2:C2)) // returns 2
=AREAS((F17:F19,J16:J18,I8)) // returns 3

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas