Skip to main content

COLUMNS function

The COLUMNS function is one of the lookup and reference functions. It is used to return the number of columns in a cell reference.

Syntax​

COLUMNS(array)

The COLUMNS function has the following argument:

ArgumentDescription
arrayA reference to a range of cells.

Notes​

How to apply the COLUMNS function.

Examples​

The figure below displays the result returned by the COLUMNS function.

COLUMNS Function