Learn How to Use Microsoft Excel AREAS Function

Microsoft Excel AREAS Function

The main objective of the Microsoft Excel AREAS function is to get the number of areas in a reference. So, you able to return the number of areas in a provided reference with the help of the AREAS function. So, when we use the formula = AREAS((A1:C1, A2:C2)), the return value will be 2. In case you want to use multiple references, they should be enclosed in the extra set of parenthesis.

AREAS Function Return Value

The return value will be the number representing a number of areas.

AREAS Syntax

= AREAS(reference)

Where the argument:

• reference: It is the reference of a particular cell or the range of cells.

How to Use Microsoft Excel AREAS Functions?

You can include more than one reference in the AREAS function and separate the multiple references using a comma and enclose them in an extra parenthesis set. Otherwise, Excel will regard commas as multiple arguments and generate an error. 

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel