COLUMNS function
Summary
Returns the number of columns in a reference
Syntax
COLUMNS(array)
The COLUMNS function syntax has the following argument:
• Array Required. An array or array formula, or a reference to a range of cells for which you want the number of columns.
• Array Required. 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)
=COLUMNS({1,2,3;4,5,6})
=COLUMNS({1,2,3;4,5,6})