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.

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

Excel formula: Count columns that contain specific values

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

COLUMNS Function

The Excel COLUMNS function returns the count of columns in a given reference.

ROWS Function

The Excel ROWS function returns the count of rows in a given reference.

Excel formula: Max of every nth column

Excel formula: Get relative column numbers in range

Excel formula: Address of last cell in range

Excel formula: Increment a calculation with ROW or COLUMN

Excel formula: Convert column letter to number

Excel formula: Get location of value in 2D array

Excel formula: Multiple matches into separate columns

Excel formula: Address of first cell in range

Excel formula: Count rows with at least n matching values

Excel formula: Count rows that contain specific values

Excel formula: Sum every nth column

Excel formula: Fixed value every N columns

Excel formula: Sum every 3 cells

Excel formula: Index and match on multiple columns

Article image

Excel ROW function

Excel COLUMNS function

Excel ROWS function