Sponsored Link
Purpose
Get the number of areas in a reference.
Return value
A number representing number of areas.
Syntax
=AREAS (reference)
Arguments
- reference – A reference to a cell or range of cells.
Usage notes
Reference can include more than one reference. you must separate multiple references with a comma and wrap then in an extra set of parentheses. Otherwise, Excel will think the commas indicate multiple parameters and generate an error.
As an example, the formula =AREAS((F17:F19,J16:J18,I8)) will return 3.