The AREAS function

Share on facebook
Share on twitter
Share on linkedin
Share on telegram
Share on whatsapp


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:

Subscribe to our Newsletter

We will not send you SPAM mail. We hate it as much as you.