COLUMNS

Returns the number of columns in the specified range or array.

Syntax

COLUMNS( ReferenceOrArray r ) → Integer

Parameters

r

Required. A reference to a range of cells or an array for which to return the number of columns.

Example

Formula

=COLUMNS(A1:E4)
=COLUMNS({1;2;3|4;5;6})

See Also

Function Reference
ROWS Function