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:   Cell References: Relative, Absolute and Mixed Referencing Examples

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 get random value from list or table in Excel
Worked Example:   Automatically fill series of cells in Excel using AutoFill

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 *