Manuals/calci/AREAS

Revision as of 21:29, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''AREAS'''</font></font></font><font color="#48484...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
 AREAS(ref)

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


 It gives the number of areas in a reference.

AREAS


 

Let's see an example

=AREAS(B3:D5) is 2


Syntax

Examples

Description

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