COLUMNSReturns the number of columns in a specified array or range.
Sample Usage
COLUMNS(A9:W62)
COLUMNS({1,2,3,4,5})
Syntax
COLUMNS(range)
range – The range whose column count will be returned
See Also
ROWS: Returns the number of rows in a specified array or range.
ROW: Returns the row number of a specified cell.
COLUMN: Returns the column number of a specified cell, with `A=1`.
Examples
Returns the number of columns in the given reference.