Excel has several built-in features that help analyze data. For example, you can count the number of entries in your form by selecting those rows and you will see the count on the bottom right corner. However, this is a repetitive task, one that can be handled with a simple formula. In this article we’re going to show you how to get the number of rows using the ROWS function.

Syntax

=ROWS(cell or range reference you want to get its row count)

Steps

  1. Begin by typing in =ROWS(
  2. Select or type in the range that contains the reference (i.e. B2:G7)
  3. Type in ) and press the Enter key to complete the formula

How

The ROWS function returns the row count of the target reference or array. The function only needs one input parameter. In our example, we used,

=ROWS(B2:G7)

=ROWS({75,95,47,5,9,85;24,49,79,96,95,78;47,99,94,86,28,31;52,55,61,65,94,50;36,29,4,72,17,49;15,43,10,80,83,97})

The ROWS function is helpful to provide information about dynamic ranges whose dimensions can vary when updated. Also, incremental number series can be calculated by using an expanding range in the ROWS function. Use the $A$1:A1 range reference, and copy it down to generate a number sequence. For example,

=ROWS($A$1:A1)

Also see our guide on how to remove blank cells guide to further automate your data tables.