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. | ||
| + | ==Description== | ||
| − | |||
| − | |||
*It gives the number of areas in a reference. </font></font></font></div> | *It gives the number of areas in a reference. </font></font></font></div> | ||
Let's see an example</font></font></font> | Let's see an example</font></font></font> | ||
Revision as of 04:43, 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.
Let's see an example
=AREAS(B3:D5) is 2
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | ||||
| Row2 | 7 | 2 | ||
| Row3 | ||||
| Row4 | 10000 | |||
| Row5 | ||||
| Row6 |