| Syntax |
| =AREAS(reference) |
| Purpose / Description |
| Returns the count of areas in a referenced range. |
| Arguments |
| Name |
Type |
Description |
| reference |
reference |
A reference or a nested expression that returns a reference, whose number of areas is to be determined. |
| Return Values |
| Type |
Specific Value |
Description |
| number |
|
The number of areas in a referenced range. |
| error |
|
If a single error value is passed to the array argument, the result is the error value. |
| Notes / Comments / Advice / Warnings |
| Note: |
Only references and errors can be passed to the areas function. |
| Examples: |
Open / download sample workbook: AREAS, COLUMN, COLUMNS, ROW, ROWS, SHEET, SHEETS.xlsx |
| |