Skip to Content

COLUMNS

Returns the number of columns in a reference or array

Syntax

COLUMNS(array)

Parameters

  • array: Required. An array or array formula, or a reference to a range of cells

Example

=COLUMNS(A1:D5)
Returns: NumberSince: Excel 2003