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.