## How to use the AREAS function

*Article updated on February 27, 2018*

The AREAS function returns the number of cell ranges and single cells in a reference.

Formula in cell B3:

### Excel Function Syntax

AREAS(*reference*)

### Arguments

reference |
Required. A reference to a cell(s) or a cell range(s). |

### Comments

Use parentheses to include multiple arguments as a single argument.

### Functions in 'Lookup and reference'

The AREAS function function is one of many functions in the 'Lookup and reference' category.