Author: Oscar Cronquist Article last updated on March 27, 2018

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

Formula in cell B3:

=AREAS(E3:E4)

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.