Excel AREAS Function
Summary
The Excel AREAS function returns the number of areas in a given reference. For example, =AREAS((A1:C1,A2:C2)) returns 2. Multiple references must be enclosed in an extra set of parentheses.
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.
Version
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 arguments and generate an error.
Example:
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
