Spreadsheet.com Support Functions Lookup functions ROWS Returns the number of rows in a specified array or range. Sample Usage ROWS(C5:K25) Syntax ROWS(range) range - The range whose rows are to be counted. Examples ROWS(C5:K25) returns the number of columns in the reference C5:K25 i.e. 21.