COLUMNS

See also A-Z Spreadsheet Function List

Description Returns the number of columns in a range reference.

Syntax COLUMNS(range)

range is a reference to a range of cells.

See Also COLUMN and ROWS functions

Example COLUMNS(A1:D5) returns 4