COLUMNS

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.

Was this helpful?
How can we improve it?