ROWS function returns the number of rows against a reference or array. For example, =ROWS(E5:E8) returns 4, because there 4 rows in the range.
The function has the following argument:
array – Required. a reference, an array or range of cells for which number of rows needed.
For more detail, visit Microsoft Office website.
ROW function returns the row number for a reference. For example, =ROW(B2) returns ‘2’ because B2 is the second row in the spreadsheet.
COLUMN function returns the column number against the given cell reference.
COLUMNS function uses to find out the number of columns in a selected array or reference.