Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

AREAS

Find number of areas in reference in Excel
Returns the number of areas in a reference

Rational

Find number of areas in reference.

Description

The Excel AREAS function returns a number of areas or region of given references.
For example, =AREAS((B2:C4,D8:F9)) returns 2 (number of areas). The user must include extra sets of parentheses in case of more than one reference in the argument ((reference)).

Syntax

= AREAS(reference)

Parameters

reference – The references to find a number of areas

Return Value

An integer representing the number of areas

Key Notes

  • The AREAS function finds the number of regions in the argument.
  • In the case of multiple references, a comma is used to separate each reference and enclosed with an extra set of parentheses.

Keep Reading Similar Functions:

Find column number for a reference in Excel

COLUMN

The COLUMN function returns the column number of a first reference cell. For example, =COLUMN(E10:F10) returns 5 (5th column, a sequence of E in alphabets).

Read More »
Return address of a cell in Excel

ADDRESS

The ADDRESS function returns cell address from given row and column numbers of a worksheet. For example, if you pass ADDRESS(5,6) the function returns $F$5.

Read More »
Count of rows in a cell range in Excel

ROWS

The ROWS function returns the number of rows of a cell range or array formula, =ROWS(E10:F100) returns 91 (91 rows in the cell range i.e. 10 to 100).

Read More »
Find ROW number of a reference in Excel

ROW

The ROW function returns the row number of a reference cell. For example, =ROW(E9:E10) returns 9 (9th from top to bottom, only the first cell).

Read More »
Count all columns of a cell range in Excel

COLUMNS

The COLUMNS function returns a count of all columns of a cell range or array formula, =COLUMNS(E10:F100) returns 2 (two columns E & F).

Read More »