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