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.


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