Lookup Reference Functions MSOfficeExcel 2007 Tutorial

  1. Home
  2. MSOfficeExcel 2007 Tutorial
  3. Lookup Reference Functions
  4. =COLUMNS({1,2,3;4,5,6}) returns the number of columns in the array constant
Input the formula: =COLUMNS({1,2,3;4,5,6}). Press Enter to get the result.