Skip to content
Excel

AREAS function in Excel

Returns the number of areas in a reference

=AREAS(reference)

AREAS syntax and parameters

One argument, one required.

  • referencerangeRequired

    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.

AREAS examples

Formulas you'll actually reuse.

  1. Count the blocks in a multi-area reference (note the extra parentheses):

    =AREAS((A2:C50, E2:G50))

    Result2

  2. How many separate ranges a named range covers:

    =AREAS(SalesRegions)

    Result3

AREAS in Google Sheets

No direct equivalent — here's the way around.

Try AREAS in the playground

Edit the example — nothing to install.

Preloaded with the AREAS formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.