Cellgrids Cellgrids
Home › Excel formulas › Lookup and Reference › AREAS

AREAS Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

AREAS is an Excel Lookup & Reference function. Returns the number of separate areas in a reference.

AREAS syntax

=AREAS(reference)

Arguments

When to use AREAS

AREAS is used to pull matching data from one part of a workbook into another.

Practice AREAS online, free

Open the live Excel-style spreadsheet and try AREAS yourself. No Excel install or sign-up needed to start.

Practice AREAS now →

More Lookup & Reference functions

Frequently asked questions

What does the AREAS function do in Excel?

Returns the number of separate areas in a reference.

What is the syntax of AREAS in Excel?

The syntax is =AREAS(reference). reference: The cell or range being referenced.

Where can I practice AREAS online for free?

Open the free live spreadsheet on Cellgrids and try AREAS yourself. No Excel install is needed and you can start without signing up.

All Excel formulas · Cheat sheet · Excel exercises · Lookup and Reference functions · Excel case studies · Excel tutorials · Excel shortcuts