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, where the function 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

Excel Areas Function Example 2

The following spreadsheet shows another example of the AREAS function, where the reference is a named range (called '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.

 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  

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-2014 ExcelFunctions.net