To calculate the total number of rows in a range, here’s what we can do:

Example:

total number of rows

We have taken colour and sales in reference to products.

Previously: How to build a summary count of non-blank categories in excel?

Now, to calculate the no. of rows, this is what we will do:

total number of rows

We will use the ROWS Function.

*Please note: that we are using the ROWS Function and not ROW Function.

=ROWS(

The following function requires array.

total number of rows

The array in the above example is our overall data, which is B3:D9.

total number of rows

So overall, the formula becomes:

=ROWS(B3:D9)

total number of rows

Now, all we have to do is press enter.

And BAAAAMMMM!!! The answer is 7 i.e. the total no. of rows in the range (or array) are 7 in total.

total number of rows

It’s easy, isn’t it?