AREAS function
Summary
Returns the number of areas in a reference
Syntax
AREAS(reference)
The AREAS function syntax has the following argument:
• 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. See the following example.
• 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. See the following example.
Example
=AREAS(B2:D4)
=AREAS((B2:D4,E5,F6:I9))
=AREAS(B2:D4 B2)
=AREAS((B2:D4,E5,F6:I9))
=AREAS(B2:D4 B2)