Difference between revisions of "Manuals/calci/AREAS"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''AREAS(ref)'''</div><br/> | <div style="font-size:30px">'''AREAS(ref)'''</div><br/> | ||
<math>ref</math> is a reference to a cell or range of cells and can refer to multiple areas. | <math>ref</math> is a reference to a cell or range of cells and can refer to multiple areas. | ||
| + | |||
==Description== | ==Description== | ||
| − | *It gives the number of areas in a reference. | + | *It gives the number of areas in a reference. |
| − | Let's see an example | + | *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) is 2 | ||
| + | =AREAS((B3:D5,E7,F5:I3)) is 3 | ||
| + | ==Examples== | ||
| + | ==See Also== | ||
| + | ==References== | ||
{| id="TABLE1" class="SpreadSheet blue" | {| id="TABLE1" class="SpreadSheet blue" | ||
Revision as of 04:54, 22 November 2013
AREAS(ref)
is a reference to a cell or range of cells and can refer to multiple areas.
is a reference to a cell or range of cells and can refer to multiple areas.
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
See Also
References
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | ||||
| Row2 | 7 | 2 | ||
| Row3 | ||||
| Row4 | 10000 | |||
| Row5 | ||||
| Row6 |