Excel COLUMNS Function
How to use the COLUMNS Function (WS)
This Excel tutorial explains how to use the Excel COLUMNS function with syntax and examples.
SUMMARY:
The Excel COLUMNS function returns the count of columns in a given reference.
For example,
- COLUMNS(A1:C3) returns 3, since the range A1:C3 contains 3 columns.
PURPOSE:
To get the number of columns in an array or reference.
RETURN VALUE:
The COLUMNS function returns number of columns. It returns a numeric value.
SYNTAX:
=COLUMNS(array)
ARGUMENTS:
The COLUMNS function syntax has the following arguments:
- Array: Required. An array or array formula, or a reference to a range of cells for which you want the number of columns.
- A reference to a range of cells.
REMARKS:
- Use the COLUMNS function to get the column count for a given reference or range.
