What is the syntax for AREAS in Excel?

The syntax for AREAS is: =AREAS(reference)

What are common errors with AREAS?

Must use parentheses for multiple areas

What is AREAS used for in Excel?

AREAS counts how many separate ranges are in a reference. =AREAS(A1:B2) returns 1 (one contiguous range). =AREAS((A1:B2,D1:E2)) returns 2 (two separate ranges). Useful for validating multi-area selections.

Why do I need extra parentheses for multiple areas?

Excel requires double parentheses for union references: =AREAS((A1:B2,C1:D2)). The outer parentheses are for the function, the inner ones create the union. Without inner parentheses, Excel treats commas as argument separators.

How do I use AREAS with INDEX for multi-area references?

INDEX can return values from specific areas: =INDEX((A1:B2,D1:E2), 1, 1, 2) returns D1 (row 1, col 1 of area 2). AREAS tells you how many areas exist, INDEX accesses specific areas.

Lookup & Reference

AREAS Function in Excel

Returns the number of areas in a reference. An area is a range of contiguous cells or a single cell.

Syntax

=AREAS(reference)

Arguments

reference (required): A reference to a cell or range of cells

Examples

=AREAS(A1:B2) - Count areas in single range - Result: 1
=AREAS((A1:B2,C3:D4)) - Count areas in multiple ranges - Result: 2
=AREAS((A1,B2,C3)) - Count individual cells as areas - Result: 3

When to use AREAS

Use AREAS when you need to retrieve values from a table or range based on a key.
Confirm data types match (text vs number) and trim spaces before lookups.
Pair with [IFERROR](/functions/iferror/) or [IFNA](/functions/ifna/) for cleaner reports.
See the [lookup functions guide](/guides/excel-lookup-functions-guide/) for VLOOKUP, XLOOKUP, and INDEX MATCH paths.

Common AREAS mistakes

#N/A often means the key is missing or exact match is wrong — see [#N/A error](/errors/na/).
Lock table references with $ when copying formulas down a column.
Compare legacy vs modern lookups in [XLOOKUP vs VLOOKUP](/compare/xlookup-vs-vlookup/).

Common errors

Must use parentheses for multiple areas

Use cases

Counting discontinuous ranges
Dynamic range analysis
Formula validation

Frequently asked questions

What is AREAS used for in Excel? AREAS counts how many separate ranges are in a reference. =AREAS(A1:B2) returns 1 (one contiguous range). =AREAS((A1:B2,D1:E2)) returns 2 (two separate ranges). Useful for validating multi-area selections.
Why do I need extra parentheses for multiple areas? Excel requires double parentheses for union references: =AREAS((A1:B2,C1:D2)). The outer parentheses are for the function, the inner ones create the union. Without inner parentheses, Excel treats commas as argument separators.
How do I use AREAS with INDEX for multi-area references? INDEX can return values from specific areas: =INDEX((A1:B2,D1:E2), 1, 1, 2) returns D1 (row 1, col 1 of area 2). AREAS tells you how many areas exist, INDEX accesses specific areas.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.