The Excel AREAS function counts the number of areas in a given reference. For example, =AREAS((A1:B1, A2:B2, A3:B3)) returns 3.

## How to use the Excel AREAS function

The purpose of the functions is to return the number of areas in a reference. The function is available in Excel 2003 and above.

Areas are separated adjacent ranges. So, in Excel, a single cell reference is equivalent to an area. Using the function, you can add more than one reference as an **argument**.

**Syntax**

**=AREAS(reference)**

### Arguments

The AREAS function uses only one argument, cell reference(s).

### Examples

In the example below, the formula that uses the AREAS function returns with 1:

**=AREAS(C1:D1) = 1**

If you want to add multiple references, you should use commas to separate them.

**=AREAS((A1:B1, C1:D1)) = 2**

**Tip:** if you use more than one reference, configure the function carefully. Use double brackets; else Excel returns an error:

**“You have entered too many arguments for this function.”**

To fix this **formula error**, go to the Formula Bar, and add an extra bracket!

**Additional resources:**