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

ROWS(array)

 
 Returns the number of rows in a cell range or reference.

 arrayThe array or array formula containing the number of rows.

 REMARKS
 
  		• If "array" is not an array, then #VALUE! is returned.

     EXAMPLES
     
     AB
    1=ROWS(B1:B4) = 45
    2=ROWS(B3) = 110
    3=ROWS({1,2,3;4,5,6}) = 215
    4=ROWS({1,2,"some text"}) = 120
    5=ROWS("some text") = #VALUE! 
    		 
     Functions - R | Index - R | Office Online 

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