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