Difference between revisions of "Manuals/calci/AREAS"

From ZCubes Wiki
Jump to navigation Jump to search
(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...")
(No difference)

Revision as of 02:29, 25 October 2013

 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