Lookup Reference Functions MSOfficeExcel 2007 Tutorial

  1. Home
  2. MSOfficeExcel 2007 Tutorial
  3. Lookup Reference Functions
  4. 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})