COLUMNS Function Explained

The COLUMNS function in Microsoft Excel returns the number of columns in an array or reference. It takes a single argument, which can be an array or a reference to a range of cells. The function returns the number of columns in the array or reference.

COLUMNS Function Syntax

COLUMNS(array)

  • array: The array or range of cells for which you want the number of columns.