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: