HomeExcel Functions ► Excel AREAS Function

Syntax For Excel AREAS Function

What is the use of Excel AREA Function?

Use Excel AREAS Function to check numbers of areas in a reference. In simple words, It will return that how many areas you have included in a reference.

Definition For Excel AREAS Function

In above example, I have referred to 3 cells & get 3 in the result returned by areas function.

Syntax for Excel AREAS Function

AREAS(reference)

reference A Reference to a cell or a range of cells.

More information on Excel AREAS Function

  • If you want to refer to more than one cell reference, you have to enclose all that references in one more set of parentheses & use commas to separate each reference from other.
  • Reference can be a cell or a range of cells.

Examples to understand Excel AREAS Function

Examples For Excel AREAS Function

In above example, I have used areas function to get the number reference in a named range.

Download Sample File

Download Sample File To Learn Excel AREAS Function

More Tips Related With Excel AREAS Function

Conclusion

Use Excel AREAS Function to count numbers of areas you have used in a reference. Learn more about AREAS from here.

Related Functions

Rows | Columns

Excel Functions | Excel Formulas