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.
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.
---