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...") |
(No difference)
|
Revision as of 02:29, 25 October 2013
AREAS(ref)
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.
AREAS
Let's see an example
=AREAS(B3:D5) is 2
Syntax
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | ||||
| Row2 | 7 | 2 | ||
| Row3 | ||||
| Row4 | 10000 | |||
| Row5 | ||||
| Row6 |