How to use the AREAS Function in Excel

Description

The AREAS Function is categorized as Lookup & Reference Function in Excel. This function returns total number of area in a given reference as arguments. A area indicates to a single single cell reference or contiguous cell reference.

The AREAS function takes one argument which is cell reference . Use extra set of parenthesis if multiple cell reference is used.

Syntax

The syntax of AREAS function is =AREAS(reference)

Argument or Parameter

reference (Required)- can be a reference to cell or range of cells or Named Range.

Use extra set of parenthesis if multiple cell reference is used.

Returns

The AREAS function returns total number of areas with given cell reference or cell references.

Example

Example-1

In the example given below, we will understand about the AREAS function.

In C11, Formula used is =AREAS(L1). L1 is single cell reference so it returns 1.

In C12, Formula used is =AREAS(M1:M6). M1:M6 is a single contiguous cell reference so it returns 1.

In C13, Formula used is =AREAS((K1,K2:O3,K4:K8)). K1 is single reference, K2:O3 and K4:K8 is two contiguous cell reference. As this formula contains three different reference it returns 3.

In C14, Formula used is =AREAS(AREA1). AREA1 is a named range of cell reference L2:L7. So it returns 1.

In C15, Formula used is =AREAS((AREA1,AREA2,AREA3)), AREA1,AREA2 and AREA3 is named range, sot it returns 3.

In C16, Formula used is =AREAS((K5:K9,AREA1)), in this formula we have 2 references so it returns 2.

In C17, Formula used is =AREAS((A B)), here A and B is two different named range. In this formula we have not used comma(,) between two reference because we will find intersection area of two cell reference. So its returns 3.

Named Range reference:

AREA1 = $L$2:$L$7
AREA2 = $N$3:$N$7
AREA3 = $P$3:$P$7
A = AREAS!$N$3:$N$12,AREAS!$P$3:$P$12 (Here in the cell reference AREAS is sheet name)
B = AREAS!$N$3:$N$12,AREAS!$P$3:$P$12 (Here in the cell reference AREAS is sheet name)

Notes

Use extra parenthesis if multiple cell reference is used.
Do not use comma between two reference if you want to find area intersection.

********************************* ~:Support Our Work Financially:~ *********************************

Project File Type: Free

If you think this tutorial helps you to solve your problem and add value to your work, Buy me a Coffee..

************************************************************************************************

LOOKUP & REFERENCE FUNCTION
ADDRESS	AREAS	CHOOSE	COLUMN	COLUMNS
FORMULATEXT	GETPIVOTDATA	HLOOKUP	HYPERLINK	INDEX
INDIRECT	LOOKUP	MATCH	OFFSET	ROW
ROWS	RTD	TRANSPOSE	VLOOKUP