Excel AREAS Function
How to use the AREAS Function (WS)
This Excel tutorial explains how to use the Excel AREAS function with syntax and examples.
SUMMARY:
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.
PURPOSE:
To Get the number of areas in a reference.
RETURN VALUE:
The ROW function returns a numeric value, representing number of areas.
SYNTAX:
=AREAS(reference)
ARGUMENTS:
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.
REMARKS:
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.
