Microsoft Office Tutorials and References
In Depth Information
Using AREAS and INDEX to Describe a Range with More Than One Area
Figure 12.34.
Figure 12.34. These functions describe the location and shape of a range.
These functions describe the location and shape of a range.
Using
Using AREAS
to Describe a Range with More Than One Area
All the functions listed in the preceding section fail if the referencede-
scribes a noncontiguous range. However, you can check for that condition by
using the AREAS function.
AREAS and
and INDEX
INDEX to Describe a Range with More Than One Area
Syntax
AREAS(reference)
This function returns the number of contiguous ranges in a reference. The ar-
gument referenceusually refers to a named range.
In Figure 12.35 , MyAreas is a defined name that describes the cells in black.
In rows 1 through 4, all the traditional functions fail with #REF! errors be-
cause the reference contains more than one contiguous range.
Search JabSto ::




Custom Search