Las areas function
When it's used, the AREAS The function returns the number of areas in a reference. An area is a continuous cell range or a single cell. If a range is made up of contiguous cells, the range number is based on the number of separate references (see second example below).
We are not 100% unsure where i could use this, except in a series of blogs about all Excel functions …
The AREAS The function uses the following syntax to operate:
AREAS (reference)
- reference: a reference to a cell or range of cells and can refer to multiple areas. If you want to specify multiple references as a single argument, You must include an additional set of parentheses so that Microsoft Excel does not interpret the comma as a field separator.
Please, see my example below:
