The AREAS function returns the number of ranges the function references.
AREAS(areas)
areas: The areas the function should count. areas is a list value. It is either a single range or more than one range separated by commas and enclosed in an additional set of parentheses; for example, AREAS((B1:B5,C10:C12)).
Examples |
|---|
=AREAS(A1:F8) returns 1. =AREAS((A1:F8, A10:F18)) returns 2. =AREAS((A1:C1, A3:C3, A5:C5)) returns 3. |