AREAS function in excel

Version in which AREAS function can work:

AREAS function in excel will work in Excel for Android phones Excel Mobile Excel Starter Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets.

About AREAS function in excel:

The Excel AREAS function returns the number of areas in a reference. The area can be a range of contiguous cells or a single cell.

Syntax for excel AREAS Function:



reference: Reference is a required field, This is a reference to a cell or range of cells. You can give reference to multiple area in a formula. In case multiple references are given in a formula, the references should be closed with the two parentheses.

You can also give Named Ranges as reference in this formula.


This function is very much helpful to check the references in a named range.

Using AREAS function:

You can see some of the examples of Excel AREAS function for better understanding. These examples includes singe reference, multiple reference and named range reference in the formula.

Formula Result Comment
 =AREAS(A2) 1 Single reference formula.
 =AREAS((I5:I6,H9:H11,K5:K8)) 3 Multiple references in a formula. (You should cover Range with two Parentheses).
 =AREAS(test_range) 4 Named range references. Test_range consists of 4 references.

areas function in excel

Add a Comment

Your email address will not be published. Required fields are marked *