Difference between revisions of "Documentation/How Tos/Calc: AREAS function"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Initial content)
 
m
 
(10 intermediate revisions by 5 users not shown)
Line 1: Line 1:
−
__NOTOC__
+
{{DISPLAYTITLE:AREAS function}}
 +
{{Documentation/CalcFunc SpreadsheetTOC
 +
|ShowPrevNext=block
 +
|PrevPage=Documentation/How_Tos/Calc:_VLOOKUP_function
 +
|NextPage=Documentation/How_Tos/Calc:_COLUMN_function
 +
}}__NOTOC__
  
 
== AREAS ==
 
== AREAS ==
Line 9: Line 14:
 
: <tt>'''reference'''</tt> may consist of multiple ranges. <tt>'''AREAS'''</tt> returns the count of these ranges.
 
: <tt>'''reference'''</tt> may consist of multiple ranges. <tt>'''AREAS'''</tt> returns the count of these ranges.
  
−
: This is mostly useful with a named reference; multiple ranges may be entered from '''Insert - Names - Define...''' by manually concatenating ranges in the '''Assigned To''' box.
+
: This is mostly useful with a named reference; multiple ranges may be entered from {{menu|Insert|Names|Define…}} by manually concatenating ranges in the '''Assigned To''' box.
  
 
=== Example: ===
 
=== Example: ===
Line 16: Line 21:
  
 
<tt>'''AREAS(myref)'''</tt>
 
<tt>'''AREAS(myref)'''</tt>
−
: where you have defined <tt>'''myref'''</tt> in '''Insert - Names - Define...''' to be two ranges (eg by entering <tt>'''A1:A3;C1:C4'''</tt> in the '''Assigned To''' box), returns <tt>'''2'''</tt>.
+
: where you have defined <tt>'''myref'''</tt> in {{menu|Insert|Names|Define…}} to be two ranges (eg by entering <tt>'''$A$1:$A$3;$C$1:$C$4'''</tt> in the '''Assigned To''' box), returns <tt>'''2'''</tt>.
  
−
=== See also: ===
+
{{SeeAlso|EN|
−
'''[[Documentation/How_Tos/Calc: ROWS function|ROW]]''',
+
* [[Documentation/How_Tos/Calc: ROWS function|ROWS]]
−
'''[[Documentation/How_Tos/Calc: COLUMNS function|COLUMNS]]''',
+
* [[Documentation/How_Tos/Calc: COLUMNS function|COLUMNS]]
−
'''[[Documentation/How_Tos/Calc: SHEETS function|SHEETS]]'''
+
* [[Documentation/How_Tos/Calc: SHEETS function|SHEETS]]
  
−
'''[[Documentation/How_Tos/Calc: Information functions|Information functions]]''',
+
* [[Documentation/How_Tos/Calc: Information functions|Information functions]]
−
'''[[Documentation/How_Tos/Calc: Spreadsheet functions|Spreadsheet functions]]'''
+
* [[Documentation/How_Tos/Calc: Spreadsheet functions|Spreadsheet functions]]
 +
 
 +
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 +
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 +
[[Category: Documentation/Reference/Calc/Spreadsheet functions]]

Latest revision as of 11:56, 2 February 2024



AREAS

Returns the number of areas in a given reference.

Syntax:

AREAS(reference)

reference may consist of multiple ranges. AREAS returns the count of these ranges.
This is mostly useful with a named reference; multiple ranges may be entered from Insert → Names → Define… by manually concatenating ranges in the Assigned To box.

Example:

AREAS(A5:B7)

returns 1. The reference A5:B7 is a single range.

AREAS(myref)

where you have defined myref in Insert → Names → Define… to be two ranges (eg by entering $A$1:$A$3;$C$1:$C$4 in the Assigned To box), returns 2.


See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_AREAS_function&oldid=259987"
Views
Personal tools
Navigation
Tools