Manuals/calci/COLUMNS

COLUMNS(arr)

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

Description

• This function gives the number of columns in an given array or in the reference of cell range.
• i.e.COLUMNS(A3:H5)IS 8 because number of cells containing 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 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

• COLUMN
• ROW

References

Complex Numbers