=AREAS(B2:D4 B2) returns the number of areas in the range : AREAS « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =AREAS(B2:D4 B2). Press Enter to get the result.
Input the formula: =AREAS(B2:D4 B2) Number of areas in the range
19.2.AREAS
19.2.1.AREAS returns the number of areas in a referenceAREAS returns the number of areas in a reference
19.2.2.To specify several references as a single argument, include extra sets of parenthesesTo specify several references as a single argument, include extra sets of parentheses
19.2.3.=AREAS(B2:D4 B2) returns the number of areas in the range=AREAS(B2:D4 B2) returns the number of areas in the range