Manuals/calci/AREAS

AREAS(ref)

$ref$ is a reference to a cell or range of cells and can refer to multiple areas.

Description

• It gives the number of areas in a reference.

Let's see an example

=AREAS(B3:D5) is 2

	Column1	Column2	Column3	Column4
Row1
Row2	7	2
Row3
Row4			10000
Row5
Row6