AREAS function.Get the number of regions within a specified cell range.(Microsoft Excel)

Japanese version.

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)
ArgumentOmissionSpecify
referenceRequired argument.Target cell range.

Example Results

Multiple ranges can be specified by cell range name or () for references.

---

Links

Lookup & Reference(Microsoft Excel Functions)