writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: + − + − + − + + + + + +
no edit summary
<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. </font></font></font></div>
*It gives the number of areas in a reference.
Let's see an example</font></font></font>
*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"