Documentation/Calc Functions/AREAS

Function name:
AREAS

Category:
Spreadsheet

Summary:
Determines the number of individual areas in a given reference. A reference may comprise one or more areas, where each area comprises a single cell or a block of contiguous cells.

Syntax:
AREAS(Reference)

Returns:
Returns a positive integer that is the number of areas within the supplied reference.

Arguments:
Reference is the reference to be analyzed.


 * Single references take the form of a specific cell reference (for example, "$Sheet1.A1"), a specific cell range (for example, "$Sheet1.$C$28:$H$29"), or the name of a named or database range. AREAS is particularly useful with named ranges defined using on the Menu bar, because they can be configured to comprise multiple areas by using the tilde reference concatenation operator in the Range or formula expression field of the Define Name dialog.


 * Multiple references can be passed as a single argument by providing them in a separated list, surrounded by parentheses – for example, . In this case Calc will reformat your function call to use the tilde reference concatenation operator – for example  . Alternatively, you can use the tilde reference concatenation operator directly without parentheses – for example.


 * AREAS counts repeated or overlapping areas as separate entities. For example,  returns 3.


 * If Reference is not a valid reference list, then AREAS reports a parameter list error (Err:504).

Additional details:
None.

Related LibreOffice functions:
INDEX

ODF standard:
Section 6.13.2, part 2

Equivalent Excel functions:
AREAS