COLUMNS Function

The COLUMNS() is a lookup and reference function which takes the argument "array" and returns the number of columns in a cell reference.

Formula:


=COLUMNS(array)
In the above syntax, the argument "array" denotes the reference to a range of cells or an array for which you need the number of columns.

Video Tutorial:


Let us see how the COLUMNS () returns the number of columns, with the help of the below video.

Learn MS Excel


Ask Questions

Ask Question