Difference between revisions of "Manuals/calci/AREAS"

Latest revision as of 16: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.

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

=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

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''AREAS(ref)'''</div><br/>
+<div style="font-size:30px">'''AREAS()'''</div><br/>
-<math>ref</math> is a reference to a cell or range of cells and can refer to multiple 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==
@@ Line 17: / Line 19: @@
   =AREAS(B2:G8:J5) is 1
   =AREAS(B2:D4:E5:F6:I9) is 1
+==Related Videos==
+{{#ev:youtube|l-1QbVlcjjI|280|center|AREAS}}
 ==See Also==
@@ Line 26: / Line 32: @@
 ==References==
 *[http://www.techonthenet.com/excel/formulas/areas.php Areas]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]