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:= AREAS (reference)
The AREAS function syntax has the following arguments:
- Reference Required. A reference to a cell or range of cells and can refer to multiple areas. If you want to specify several references as a single argument, then you must include extra sets of parentheses so that Microsoft Excel will not interpret the comma as a field separator. See the following example.
Example: Let’s look at some Excel AREAS function examples and explore how to use the AREAS function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following AREAS examples would return:
- We can either type the entire formula or, after typing “=AREAS(“ into a cell, we can use the CTRL + A, without leaving the cell, to open the “Insert Function Dialog Box” for detailed commands.
- A #NULL! error will be returned when the reference given is in an incorrect format. For example, AREAS(A2 B4) instead of AREAS(A2:A4).