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.
Version 
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

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac 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