Learn Excel - Simplify Life with Excel Concepts

Excel AREAS Function

AREAS Function

How to use the AREAS Function (WS)

This Excel tutorial explains how to use the Excel AREAS function with syntax and examples.


The Excel AREAS function returns the number of areas in a given reference. An area is a range of contiguous cells or a single cell.

For example,

  • =AREAS(A1:B1) returns 1.
  • =AREAS((A1:B1,B2:C2)) returns 2. Multiple references must be enclosed in an extra set of parentheses.


To Get the number of areas in a reference.


The ROW function returns a numeric value, representing number of areas.




The AREAS function syntax has the following arguments:

  • reference: Required. A reference to a cell or range of cells and can refer to multiple areas.
    • If you want to specify several references as a single argument, then you must include extra sets of parentheses so that Microsoft Excel will not interpret the comma as a field separator.


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.