Manuals/calci/AREAS

From ZCubes Wiki
Revision as of 04:43, 22 November 2013 by Abin (talk | contribs)
Jump to navigation Jump to search
AREAS(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