ROWS

The ROWS function returns the count of rows in a given reference as a number. For example, =ROWS(A1:A5) returns 5, since the range A1:A5 contains 5 rows. ROWS takes just one argument, called array, which can be a range or array. Use the ROWS function to get the row count for a given reference or range. For example, there are 10 rows in the range A1:F10 so the formula below returns 10: The range A1:Z100 contains 100 rows, so the formula below returns 100: You can also use the ROWS function to get a row count for an array constant: Although there is no built-in function to count the number of cells in a range, you can use the ROWS function together with the COLUMNS function like this: