Excel Function Translator Logo
    The Excel Translator

    ROWS

    Lookup & Reference

    Returns the number of rows in a reference or array.

    Translations
    EnglishROWS
    FrenchLIGNES
    SpanishFILAS
    GermanZEILEN
    ItalianRIGHE
    PortugueseLINS
    DutchRIJEN
    PolishILE.WIERSZY
    RussianЧСТРОК
    TurkishSATIRSAY
    CzechŘÁDKY
    HungarianSOROK
    SwedishRADER
    DanishRÆKKER
    FinnishRIVIT
    Syntax
    ROWS(array)

    Arguments

    • arrayRange or array
    Examples
    =ROWS(A1:A10)
    10

    10 rows in range

    =ROWS(Table1)
    Table rows

    Rows in table

    =ROWS(A:A)
    1048576

    All rows in column

    Tips & Best Practices
    • •Useful for dynamic ranges
    • •Combine with INDEX for last row
    • •Works with tables and arrays
    Common Mistakes
    • •Confusing ROWS (counts the number of rows in a range) with ROW (returns a single row number) - the names look nearly identical but answer completely different questions
    • •Using ROWS on a single cell reference expecting an error or a special result - it simply returns 1, since a single cell is technically a one-row range
    • •Referencing an entire column (like ROWS(A:A)) expecting the count of used rows only - ROWS returns the sheet's full row count instead, since it counts the reference's dimensions, not which cells actually contain data
    Related Functions
    ROWReturns the row number of a single cell or the first row of a range, rather than counting how many rows a range spans.
    COLUMNSCounts the number of columns in a range, the horizontal counterpart to ROWS.
    COUNTACounts non-empty cells within a range, useful when you need the number of rows that actually contain data rather than the range's full dimension.
    Frequently Asked Questions

    What's the difference between ROWS and ROW?

    ROWS(range) counts how many rows a range spans. ROW(reference) returns the row number of a single cell or the first row of a range. One gives a count, the other gives a position.

    Why does ROWS(A:A) return over a million?

    Because you're referencing the entire column, and ROWS counts the full dimension of the reference - Excel's maximum row count - not just the rows containing data.

    What does ROWS return for a single cell reference?

    1, since a single cell is technically treated as a one-row, one-column range.

    Need to translate a formula using ROWS?

    Use our translator to convert your complete formula