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:

Argument Description
array A 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