 |
 |
|
 |
 |
|
 |
 |
 |
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-2019. HBM Prenscia Inc. ALL RIGHTS RESERVED.
 |
E-mail Link |