To specify several references as a single argument, include extra sets of parentheses : AREAS « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Lookup Reference functions
  3. AREAS
Input the formula: =AREAS((B2:D4,E5,F6:I9)). Press Enter to get the result.
Input the formula: =AREAS((B2:D4,E5,F6:I9))
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