AREAS function.Get the number of regions within a specified cell range.(Microsoft Excel)
Get the number of regions within a specified cell range.
This is the number of contiguous regions, not the number of cells.
To count cells, use the sum of the COUNTA and COUNTBLANK functions.
Contents
How it works
=FORMULATEXT(reference)
| Argument | Omission | Specify |
|---|---|---|
| reference | Required argument. | Target cell range. |
Example Results
Multiple ranges can be specified by cell range name or () for references.
---