COLUMNS takes just one argument, calledarray, which should be arangeorarray.

Examples

Use the COLUMNS function to get the column count for a given reference or range.

ROW Function

The Excel ROW function returns the row number for a reference.

Excel formula: Get relative column numbers in range

For example, ROW(C5) returns 5, since C5 is the fifth row in the spreadsheet.

When no reference is provided, ROW returns the row number of the cell which contains the formula.

COLUMN Function

The Excel COLUMN function returns the column number for a reference.

Excel formula: Address of last cell in range

For example, COLUMN(C5) returns 3, since C is the third column in the spreadsheet.

When no reference is provided, COLUMN returns the column number of the cell which contains the formula.

Excel formula: Total columns in range

Excel formula: Get address of named range or table

Excel formula: Count table columns

Excel formula: Multiple matches into separate columns

Excel formula: Last column number in range

Excel formula: Combine ranges

Excel formula: Sum last n columns

Excel formula: Average last n columns

Excel formula: Max of every nth column

Excel formula: Count cells in range

Excel formula: XLOOKUP match any column

Article image

Article image

Article image

Excel ROWS function

Excel ROW function

Excel COLUMN function