Excel AREAS function
The AREAS function takes Excel cell reference and returns the number of areas that make up the reference, the area is a range of contiguous cells or a single one. Multiple areas are separated by commas and surrounded by an extra set of parentheses. For example, the formula =AREAS(A1:A3) returns 1, then the formula v=AREAS((A1:A3,B3:E3)) returns 2.
The AREAS function returns a numeric value, which is the number of areas that make up the reference.
Here take a few examples for describing how to use the AREAS function in Excel.
You can directly input or select the cell reference in to the AREAS function, remember using comma to separate areas and inserting extra a set of parentheses if there are more than one area reference in the formula.
If there is defined name which you want to count how many ranges it contains, you can use the AREAS function.
Supposing there is a defined name called “Sale”, now use the AREAS function to count the number of areas in “Sale”.
Reference: Sale is the range name you want to find the number of areas in.
The total number of areas:3