COLUMNS
Description
Returns the number of columns in a range that you specify.
Syntax
COLUMNS(
array
)
- array: The range to return the number of columns for.
Example
Formula | Result |
|---|---|
=COLUMNS(A1:J5) | 10 |
=COLUMNS(1:1) | The number of the maximum column that has ever been used on the current
sheet. |