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: More details here.


Array can be a range or a reference to a single contiguous group of cells. Array can be an array constant or an array created by another formula. To count columns, see the COLUMNS function. To get row numbers, see the ROW function. To lookup a row number, see the MATCH function.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.