How To Use Excel ROWS Function

    how to use excel rows function

    Quick Intro

    Use Excel ROW Function to get the number of rows in an array or reference. In simple words, it will return the number of rows included in a reference.

    For example, If you refer to a range A1:B4, it will return 4 in the result.

    Syntax

    ROWS(array)

    • array A cell reference or an array to check a number of rows.

    More Information on Excel ROWS Function

    • You can also use named range in rows function.
    • Rows function is not concerned with the values in the cells, it will simply return the number of rows in a reference.

    Examples

    In the below example, I have used reference A1:A10 which has 10 rows in it and ROWS function has returned 10 in the result.

    Return Rows In A Range With Excel ROWS Function

    You can also use rows function to create a list of serial numbers. In the below example, I have used the starting cell of the reference as an absolute reference.

    Serial Numbers With Excel ROWS Function

    So, when I drag the formula down it will create a list of serial numbers.

    Sample File

    download sample file to learn more about this tips

    What’s Next?

    To learn more about Excel ROWS Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

    There is also you have ROW function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.