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.

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
11717841416931875600
true
Search Help Center
true
true
true
true
true
35
false
false