The Excel AREAS Function

The Excel Areas function takes an Excel reference and returns the number of areas that make up the reference.

The syntax of the function is :

AREAS( reference )

Where the reference argument can be input directly or can be a named range.

If the Reference argument is input directly, the different areas of cells are input as a list, separated by commas and surrounded by brackets. This is seen in the examples below.


Excel Areas Function Example 1

The following spreadsheets show simple examples of the Excel Areas function. The format of the function is shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

 Formulas:
Examples of use of the Excel Areas Function
 Results:
Excel Areas Function Results

Excel Areas Function Example 2

The following spreadsheet shows another example of the AREAS function, where the reference is the named range 'TestRange', which is made up of the 3 areas shown on the spreadsheet on the left. As shown in the spreadsheet on the right, the Areas function returns the result 3.

 Formulas:
Example of use of the Excel Areas Function
 Results:
Excel Areas Function Result
Return to the Excel Lookup & Reference Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2013 ExcelFunctions.net