COLUMNS

Syntax:

COLUMNS ( array )

Description: Finds the number of columns corresponding to array.

Arguments:

Name	Type	Description
array	array, reference	Any array.

 

Return Type and Value: number – The number of columns corresponding to array.

However, if the range of cells referred to by array is not contiguous, #NULL! is returned.

[Example:

COLUMNS(E16:F16) results in 2
COLUMNS(E16:G18) results in 3
COLUMNS({1,2;3,4}) results in 2

end example]