Returns the number of columns in the specified range or array.
Syntax
 Copy Code
|
|---|
COLUMNS( ReferenceOrArray r ) → Integer |
Parameters
- r
- Required. A reference to a range of cells or an array for which to return the number of columns.
Example
| Formula
Copy Code
|
|---|
=COLUMNS(A1:E4) |