The Excel AREAS function counts the number of areas in a given reference. For example, =AREAS((A1:B1, A2:B2, A3:B3)) returns 3.
How to use the Excel AREAS function
The purpose of the functions is to return the number of areas in a reference. The function is available in Excel 2003 and above.
Adjacent ranges are separate areas. So, in Excel, a single-cell reference is equivalent to an area. You can add more than one reference as an argument using the function.
Syntax
=AREAS(reference)
Arguments
The AREAS function uses only one argument, cell reference(s).
Examples
In the example below, the formula that uses the AREAS function returns 1:
=AREAS(C1:D1) = 1
If you want to add multiple references, you should use commas to separate them.
=AREAS((A1:B1, C1:D1)) = 2
Tip: Configure the function carefully if you use more than one reference. Use double brackets; otherwise Excel returns an error:
“You have entered too many arguments for this function.”
To fix this formula error, add an extra bracket to the Formula Bar!
Additional resources:
