Areas() Function

The Excel AREAS function returns the number of areas in a given reference. For example, =AREAS((A1:C1,A2:C2)) returns 2. Multiple references must be enclosed in an extra set of parentheses.

Syntax

The syntax for the AREAS function in Microsoft Excel is:

=AREAS( reference )

Parameters or Arguments

reference

A range of cells. If you specify more than one range, you must enclose your ranges in parentheses.

Areas Function Examples

Example 1

The following spreadsheet shows three simple examples of the Excel Areas function, where the reference argument is input directly, as a list of areas.

Formulas:

A 1 =AREAS( C1:E2 ) 2 =AREAS( ( C1:E2, B3:B5 ) ) 3 =AREAS( ( B2, C1:E3, D1:E5 ) )

Results:

A 1 1 2 2 3 3

Example 2

The following spreadsheet shows an example of the AREAS function, in which the supplied reference is a named range (called 'TestRange'), which is made up of the 3 areas shown on the 'Formula' spreadsheet below.

As shown in the 'Result' spreadsheet, the Areas function returns the result 3.

Formula:

	A	B	C	D	E
1	=AREAS(TestRange)
2
3
4
5
6

 ('TestRange' is the named range ( B1:C4, E1:E2, D5:E6 ) )

Result:

	A
1	3
2
3
4
5
6

Reference:

https://exceljet.net/excel-functions/excel-areas-function

https://www.techonthenet.com/excel/formulas/areas.php

http://www.excelfunctions.net/Excel-Areas-Function.html

follow us on http://arivilm.blogspot.in

like us on https://www.facebook.com/Arivilm2501/