COLUMNS(array)

Returns the number of columns in a cell range or reference.

arrayThe array or array formula containing the number of columns.

Remarks

* The "array" can be a cell reference, an array constant or a named range.
* If "array" is not a cell range or an array of values, the #VALUE! is returned.
* You can use the COLUMN function to return the column number of a cell reference.
* You can use the ROW function to return the row number of a cell reference.
* You can use the ROWS function to return the number of rows in a cell range or reference.
* For the Microsoft documentation refer to support.microsoft.com

 ABC
1=COLUMNS(B1:B2) = 11020
2=COLUMNS(B1:C2) = 22010
3=COLUMNS({1,2,3;4,5,6}) = 3  
4=COLUMNS({1,2,3,"some text"}) = 4  
5=COLUMNS("some text") = 1  

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top