[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
AREAS ( reference )
Description: Finds the number of areas (§3.17.2.3) designated by reference.
Arguments:
|
Name |
Type |
Description |
|
A reference to a single cell or to a range of cells that can refer to multiple areas. |
Return Type and Value: number – The number of areas designated by reference.
However, if the reference designates no areas, #NUM! is returned.
[Example:
AREAS(E312) results in 1
AREAS(E311:F313) results in 1
AREAS((E312:F314,G316:H316,G311)) results in 3, given the union of the three areas
AREAS((E312:F314 E313:F314 F312:F314)) results in 1, given the intersection of the three areas
end example]