Sunday, June 15, 2008

AREAS

AREAS - This function returns the number of individual ranges that belong to a multiple range. A range can consist of contiguous cells or a single cell.

Syntax:

AREAS(Reference)

Reference - Represents the reference to a cell or cell range.

Example:

=AREAS(A1:B3;F2:G5;J3) will return 3


Screen Shot:

No comments:

Relax. Kick your shoes off and watch a video.