Excel COLUMNS function

Function              COLUMNS

Description        Excel COLUMNS function returns the number of columns in an array or reference

Syntax  COLUMNS(array)

array  Mandatory. A reference to a cell or range of cells or an array.

Example:

=COLUMNS(D2:F5) returns 3

=COLUMNS(C2:H15) returns 6

Related Video Tutorials: