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

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.