Difference between revisions of "Manuals/calci/AREAS"

Latest revision as of 15:34, 6 August 2018

AREAS()

Parameter is a reference to a cell or range of cells and can refer to multiple areas.
- AREAS(), returns the number of areas in a reference.

Description

It gives the number of areas in a reference.
It should be surrounded with brackets, if there is more than one range.
The area can be single cell or many continuous cells

Let's see an example
=AREAS(B3:D5) is 2
=AREAS((B3:D5,E7,F5:I3)) is 3

Examples

=AREAS((B1:C4,E5)) is 2
=AREAS((B1:C4,E1,F2:J9)) is 3
=AREAS((B1:C4,E1,F2:J9,I8,N1)) is 5
=AREAS(B2:G8:J5) is 1
=AREAS(B2:D4:E5:F6:I9) is 1

References

Areas

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''AREAS'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''ref'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)</font></font></font>
+<div style="font-size:30px">'''AREAS()'''</div><br/>
+*Parameter is a reference to a cell or range of cells and can refer to multiple areas.
+**AREAS(), returns the number of areas in a reference.
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">'''where ref'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">  is a reference to a cell or range of cells and can refer to multiple areas. </font></font></font>
-</div>
+==Description==
-----
-<div id="1SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">It gives the number of areas in a reference. </font></font></font></div>
-----
-<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
-AREAS
+*It gives the number of areas in a reference.
+*It should be surrounded with brackets, if there is more than one range.
+*The area can be single cell or many continuous cells
+ Let's see an example
+ =AREAS(B3:D5) is 2
+ =AREAS((B3:D5,E7,F5:I3)) is 3
-</div></div>
+==Examples==
-----
+ =AREAS((B1:C4,E5)) is 2
-<div id="8SpaceContent" class="zcontent" align="left">
+ =AREAS((B1:C4,E1,F2:J9)) is 3
+ =AREAS((B1:C4,E1,F2:J9,I8,N1)) is 5
+ =AREAS(B2:G8:J5) is 1
+ =AREAS(B2:D4:E5:F6:I9) is 1
-<font color="#484848"><font face="Arial, sans-serif"><font size="2">Let's see an example</font></font></font>
+==Related Videos==
-<font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=AREAS(B3:D5) is 2</nowiki></font></font></font>
+{{#ev:youtube|l-1QbVlcjjI|280|center|AREAS}}
-</div>
+==See Also==
-----
+*[[Manuals/calci/ADDRESS| ADDRESS]]
-<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
+*[[Manuals/calci/CELL| CELL]]
-----
+*[[Manuals/calci/COLUMN| COLUMN]]
-<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
+*[[Manuals/calci/ROW| ROW]]
-----
-<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
-----
-<div id="4SpaceContent" class="zcontent" align="left">
-{| id="TABLE1" class="SpreadSheet blue"
+==References==
-|- class="even"
+*[http://www.techonthenet.com/excel/formulas/areas.php Areas]
-| class="         " |
-<div id="4Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
-| Column1
-| Column2
-| Column3
-| Column4
-|- class="odd"
-| class=" " | Row1
-| class="sshl_f    " |
-| class="                          " |
-| class="                        " |
-| class="                           sshl_f  " |
-|- class="even"
-| class="  " | Row2
-| class="  " | 7
-| class="sshl_f" | 2
-|
-|
-|- class="odd"
-| Row3
-| class="                                                                 " |
-| class="   " |
-|
-|
-|- class="even"
-| Row4
-|
-|
-| class=" " | 10000
-|
-|- class="odd"
-| class=" " | Row5
-|
-|
-| class="   " |
-|
-|- class="even"
-| Row6
-|
-|
-|
-| class=" SelectTD sshl_f sshl_t  SelectTD" |
-<div id="4Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="4Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
-|}
-<div align="left">[[Image:calci1.gif]]</div></div>
-----
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]