To count total rows in a range in Excel

by

If you need to count the number of rows in a range, use the ROWS function.

Worked Example:   How to return TRUE when all cells in range are blank in Excel

The ROWS counts the number of rows in the supplied range and returns that number as the result. See illustration below:

Worked Example:   How to calculate average last N values in a table in Excel
Worked Example:   Understanding Named Range, Named Constant, Name Manager in Excel Formulas

Formula

=ROWS(range)

Explanation

In the example, the active cell contains this formula:

=ROWS(B4:C9)

Leave a Reply

Your email address will not be published. Required fields are marked *