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.
Areas are separated adjacent ranges. So, in Excel, a single cell reference is equivalent to an area. Using the function, you can add more than one reference as an argument.
The AREAS function uses only one argument, cell reference(s).
In the example below, the formula that uses the AREAS function returns with 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: if you use more than one reference, configure the function carefully. Use double brackets; else Excel returns an error:
“You have entered too many arguments for this function.”
To fix this formula error, go to the Formula Bar, and add an extra bracket!