Difference between revisions of "Manuals/calci/COLUMNS"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
*<math>Array</math> is an array or a reference to a range of cells. | *<math>Array</math> is an array or a reference to a range of cells. | ||
| + | **COLUMNS(), returns the number of columns in a reference. | ||
==Description== | ==Description== | ||
Latest revision as of 16:12, 6 August 2018
COLUMNS (Array)
- is an array or a reference to a range of cells.
- COLUMNS(), returns the number of columns in a reference.
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.
Related Videos
See Also
References