Difference between revisions of "Manuals/calci/COLUMNS"

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.

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.

=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.

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''COLUMNS(arr)'''</div><br/>
+<div style="font-size:30px">'''COLUMNS (Array)'''</div><br/>
-*<math>arr</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==
@@ Line 12: / Line 13: @@
 *=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==
+{{#ev:youtube|_aNyuFjRsuk|280|center|COLUMNS}}
 ==See Also==
@@ Line 19: / Line 24: @@
 ==References==
+*[http://www.techonthenet.com/excel/formulas/columns.php Columns]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]