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...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''AREAS(ref)'''</div><br/> |
| − | |||
| − | + | '''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. </font></font></font></div> | |
| − | + | Let's see an example</font></font></font> | |
| − | |||
| − | < | ||
| − | AREAS | + | =AREAS(B3:D5) is 2 |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
{| id="TABLE1" class="SpreadSheet blue" | {| id="TABLE1" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| class=" " | | | class=" " | | ||
| − | |||
| Column1 | | Column1 | ||
| Column2 | | Column2 | ||
| Line 73: | Line 52: | ||
| | | | ||
| class=" SelectTD sshl_f sshl_t SelectTD" | | | class=" SelectTD sshl_f sshl_t SelectTD" | | ||
| − | + | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
Revision as of 04:42, 22 November 2013
AREAS(ref)
where refis a reference to a cell or range of cells and can refer to multiple areas.
- It gives the number of areas in a reference.
Let's see an example
=AREAS(B3:D5) is 2
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | ||||
| Row2 | 7 | 2 | ||
| Row3 | ||||
| Row4 | 10000 | |||
| Row5 | ||||
| Row6 |