Difference between revisions of "Manuals/calci/AREAS"
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...") |
|||
| (10 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div | + | <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. | ||
| − | |||
| − | + | ==Description== | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | 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 | ||
| − | + | ==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 | ||
| − | + | ==Related Videos== | |
| − | + | {{#ev:youtube|l-1QbVlcjjI|280|center|AREAS}} | |
| − | + | ==See Also== | |
| − | + | *[[Manuals/calci/ADDRESS| ADDRESS]] | |
| − | + | *[[Manuals/calci/CELL| CELL]] | |
| − | + | *[[Manuals/calci/COLUMN| COLUMN]] | |
| − | + | *[[Manuals/calci/ROW| ROW]] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | ==References== | |
| − | + | *[http://www.techonthenet.com/excel/formulas/areas.php Areas] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | ||
| − | + | ||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
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.
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
Related Videos
See Also
References