Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Lookup and Reference > AREAS
 

AREAS(reference)

 
 Returns the number of areas in a cell range or references.

 referenceThe reference to a range of cells.

 REMARKS
 
  		• The "reference" can refer to multiple cell ranges.
     
  		• The "reference" can be a named range or several cell references.
     
  		• If you want to specify several references as a single argument, then you must include an extra sets of parentheses (see Rows 4 & 5).
     
  		• An area is a range of contiguous cells or a single cell.

     EXAMPLES
     
     ABC
    1=AREAS(B1) = 125
    2=AREAS(B1:C1) = 1410
    3=AREAS(B1:C4) = 1615
    4=AREAS((B1:B4,C1:C4)) = 2820
    5=AREAS((B1:C4,B1:B2,C3:C4)) = 3  
    6=AREAS((B1:C2,B1)) = 2  
    7=AREAS(B1:B2 B1) = 1  
    8=AREAS(B1 B2 B3) = #NULL!  
    		 
     Functions - A | Index - A | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top