Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Lookup Reference Functions

 

ROWS(array) returns the number of rows in a reference

=ROWS({1,2,3;4,5,6})  return the number of rows in the array constant Input the formula: =ROWS({1,2,3;4,5,6})