Quick Navigation

AREAS Function

Excel 2007+

Summary

The Excel AREAS function counts the number of distinct ranges (areas) within a given reference. An 'area' represents a continuous block of cells or a single cell, making AREAS essential for analyzing complex range structures.

Syntax

AREAS(reference)

Parameters

Parameter	Type	Required	Description
reference	`Reference`	Yes	Reference to one or more cell ranges. Multiple areas require extra parentheses to avoid comma confusion.

Using the AREAS Function

AREAS helps formulas adapt to varying numbers of ranges, particularly useful when building dynamic array formulas, validating range inputs, or creating flexible lookup structures that depend on range complexity.

Common AREAS Examples

Single Range Count

=AREAS(B2:D4)

Returns 1 since B2:D4 forms a single contiguous area.

Multiple Disjoint Ranges

=AREAS((B2:D4,E5,F6:I9))

Returns 3 because the formula contains three separate areas: B2:D4, E5, and F6:I9.

Range Union with Space

=AREAS(B2:D4 B2)

Returns 1 as space-separated ranges merge into a single area.

Frequently Asked Questions

Parentheses prevent Excel from interpreting commas as argument separators, treating them as range unions instead.

Yes, each single cell in a multi-reference counts as one area.

Common Errors and Solutions

#VALUE! error

Cause: Invalid reference format or non-range argument

Solution: Ensure reference contains valid cell addresses or range notation

Notes

Areas are contiguous cell blocks - non-adjacent cells count separately
Use for INDEX array sizing in dynamic formulas
Combine with ROWS/COLUMNS for complete range analysis
Spaces between ranges create unions (single area), commas need parentheses (multiple areas)

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in:

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+