AREAS()
Syntax. AREAS(reference)
Definition. This function returns the number of contiguous ranges within a reference.
Arguments
reference (required). Must evaluate to the reference for one or more cell ranges, otherwise Excel returns an error (preventing you from entering the formula) or an error value.
Background. If your argument consists of several references separated by a comma, you need to enter additional parentheses:
=AREAS((A1,A2))
or
=AREAS((A1:A2,B3))
If you don’t enter the additional parentheses, the comma is treated as list separator and you will get an error message. If you try to calculate empty ranges, you will get the #NULL! error, as in this example, because there is no intersection between A1 and A2:
=AREAS(A1 A2)
Example. This function ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
