Manuals/calci/COLUMNS

Revision as of 07:42, 19 November 2013 by Abin (talk | contribs) (→‎References)
COLUMNS(arr)


  • is an array or a reference to a range of cells.

Description

  • This function gives the number of columns in a given array or in the reference of cell range.
  • i.e COLUMNS(A3:H5)is 8 because number of cells from cell A3 to H5 is 8.

Examples

  • =COLUMNS„(D5:G8) is 4, because number of columns in between D5 to G8 is 4
  • =COLUMNS(R5:G4) is 12, because it will considered as G4 to R5. So in between columns is 12.
  • =COLUMNS({2,4,6,8,0;1,3,5,7,9}) is 5, because it is giving the number of constants in the given array.

See Also

References