COLUMNS

Get the number of columns in an array or reference.

Sponsored Link

Purpose 

Get the number of columns in an array or reference.

Return value 

A number representing column count.

Syntax 

=COLUMNS (array)

Arguments 

  • array - A reference to a range of cells.

Usage notes 

Use the COLUMNS function to get the number of columns in a reference. For example, the formula =COLUMNS(A1:F1) returns the number 6.

Array can be an array, an array formula, or a reference to a single contiguous group of cells.

Sponsored Link

0 votes. 0 / 5