Excel: ROW, ROWS, COLUMN & COLUMNS Functions

ROW

ROW function in Excel returns the row number for a reference. For example, ROW(D7) returns 7, since D7 is the seventh row in the spreadsheet. When no reference is provided. ROW returns the row number of the cell which contains the formula. When no reference is provided, ROW returns the row number of the cell which contains the formula. ROW takes just one argument, called reference, which can be empty, a cell reference, or a range. When no reference is provided, ROW returns the row number of the cell which contains the formula.

COLUMN

COLUMN function in Excel returns the column number for a reference. For example, COLUMN(D7) returns 4, since D is the fourth column in the spreadsheet. When no reference is provided, COLUMN returns the column number of the cell which contains the formula. COLUMN takes just one argument, called reference, which can be empty, a cell reference, or a range. When no reference is provided, COLUMN returns the column number of the cell which contains the formula.

ROWS

ROWS function in Excel returns the count of rows in a given reference. For example, ROWS(C1:C10) returns 10, since the range C1:c10 contains 10 rows. Use the ROWS function to get the row count for a given reference or range. For example, there are 10 rows in the range B1:E10 so the formula below returns 10. ROWS takes just one argument, called "array", that is mandatory.

COLUMNS

COLUMNS function in Excel returns the count of columns in a given reference. For example, COLUMNS(C1:F5) returns 4, since the range C1:F5 contains 4 columns. Use the COLUMNS function to get the column count for a given reference or range. For example, there are 4 columns in the range C1:F5 so the formula below returns 4. COLUMNS takes just one argument, called "array", that is mandatory.