Functions
COLUMNS
Returns the number of columns in an array or range
Try it
When to use it
When should I use COLUMNS?
Use COLUMNS to count the number of columns in an array or range, often used in dynamic formulas to adapt to variable-width data.
Used in
Syntax
COLUMNS(array)