ROWS function, how many rows in a range

When you want to count the num­bers of rows in a range, you can use the ROWS func­tion. This func­tion looks only at rows in a giv­en range, and in the end, it returns the num­bers of rows from the select­ed range. 

=ROWS(B11:C16)

The ROWS func­tion allows you also to cre­ate a sequence of num­bers. We just have to select a prop­er range (from cell C11 to C11) (Fig. 2), but we have to lock the first C11 cell with a $ sign.

=ROWS($C$11:C11)

Then, we copy the for­mu­la down. We can see that our range keeps expand­ing because the first cell stayed the same, and the sec­ond cell keeps mov­ing down (Fig. 3)

https://www.youtube.com/shorts/_VNXxiwFqbE