AREAS

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.

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).

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).

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).

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.

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).