Related Topics: | ||
Description: Based on an array or reference, returns the number of columns.
Syntax: COLUMNS(Array)
Array is an array or array formula, or a reference to a range of cells for which you want the number of columns.
Example:
COLUMNS(C1:E4) = 3 [the number of columns in the reference]
COLUMNS({1, 2, 3; 4, 5, 6}) = 3 [the number of columns in the array constant]
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.